Re: Need input for Upgrade VPostgres 9.1.3 to PG 9.3 - Mailing list pgsql-admin

From Jim Mlodgenski
Subject Re: Need input for Upgrade VPostgres 9.1.3 to PG 9.3
Date
Msg-id CAB_5SRenoCqs6i=P87xQ0xs0WSBvS5xqrm5vPBq+Ff3J9_tozw@mail.gmail.com
Whole thread Raw
In response to Need input for Upgrade VPostgres 9.1.3 to PG 9.3  (Jeni Fifrick <jfifrick@incomm.com>)
List pgsql-admin



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


pgsql-admin by date:

Previous
From: Jeni Fifrick
Date:
Subject: Need input for Upgrade VPostgres 9.1.3 to PG 9.3
Next
From: Sergio Mior D&T
Date:
Subject: D&T Italia : Time Travel : new development : first release