Обсуждение: Need input for Upgrade VPostgres 9.1.3 to PG 9.3

Поиск
Список
Период
Сортировка

Need input for Upgrade VPostgres 9.1.3 to PG 9.3

От
Jeni Fifrick
Дата:

Hello Postgres Gurus,

We’re planning to upgrade our existing VPostgres ver 9.1.3 to Community Postgres ver 9.3. Besides upgrading the database, we’re also going to move some databases to a new server, and need to make the downtime as minimum.

I’m currently planning for the migration strategy, and need input for below questions:

1.       Is pg_upgrade works for doing the above upgrade?

2.       For setting up Streaming Replication, do Primary and Standby must be on the same version? I think it has tobe, but want to get confirmation from community.

3.       Does SLONY support the different versions of PG between Primary & Standby? OR any other solution?

4.       What are the ways to minimize the downtime during migration?

Thank you,

Jeni

Re: Need input for Upgrade VPostgres 9.1.3 to PG 9.3

От
Jim Mlodgenski
Дата:



On Tue, May 20, 2014 at 12:09 AM, Jeni Fifrick <jfifrick@incomm.com> wrote:

Hello Postgres Gurus,

We’re planning to upgrade our existing VPostgres ver 9.1.3 to Community Postgres ver 9.3. Besides upgrading the database, we’re also going to move some databases to a new server, and need to make the downtime as minimum.

I’m currently planning for the migration strategy, and need input for below questions:

1.       Is pg_upgrade works for doing the above upgrade?

VMware may have changed to on disk format a bit so pg_upgrade may not work. You'll need to check with them.
 

2.       For setting up Streaming Replication, do Primary and Standby must be on the same version? I think it has tobe, but want to get confirmation from community.

Yes, streaming replication needs to be the same version as well as the same type of OS. For example, you can replicate from 32bit Windows to 64bit Linux.
 

3.       Does SLONY support the different versions of PG between Primary & Standby? OR any other solution?

Yes
 

4.       What are the ways to minimize the downtime during migration?

Slony will be your best bet
 


Thank you,

Jeni