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