| From: | Jeni Fifrick <jfifrick(at)incomm(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Need input for Upgrade VPostgres 9.1.3 to PG 9.3 |
| Date: | 2014-05-20 04:09:28 |
| Message-ID: | E59C57F2AE0F8641B5B428292D88479F26E766C4@ATLPXCH02MB.uss.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Mlodgenski | 2014-05-20 04:18:48 | Re: Need input for Upgrade VPostgres 9.1.3 to PG 9.3 |
| Previous Message | Steve Crawford | 2014-05-19 22:37:37 | Re: Regarding server sizing for postgres database |