Two 9.1 Questions
Hello,
Now that 9.1 has been released, I have two questions:
1. Can we upgrade a 9.0 hot standby (replicating from a 9.0 master) to a 9.1 standby while still replicating from the 9.0 master? Are there any version differences that would cause a problem? We would then eventually promote the 9.1 machine to the master...
2. Is it possible to do something like the following:
A. Pause Replication on a hot standby (using the pause_at_recovery_target recovery target setting)
B. Call pg_dumpall on the slave
C. Resume replication (by disabling the pause_at_recovery_target recovery target setting)
During the pause, we would likely continue shipping WAL to the slave (unless this is unadvisable).
Is this a reasonable approach?
Thank you,
Andrew
On Mon, Sep 12, 2011 at 4:52 PM, Andrew Hannon <ahannon@fiksu.com> wrote:
Hello,
Now that 9.1 has been released, I have two questions:
1. Can we upgrade a 9.0 hot standby (replicating from a 9.0 master) to a 9.1 standby while still replicating from the 9.0 master? Are there any version differences that would cause a problem? We would then eventually promote the 9.1 machine to the master...
Not yet. That's a planned feature awaiting funding.
2. Is it possible to do something like the following:
A. Pause Replication on a hot standby (using the pause_at_recovery_target recovery target setting)
B. Call pg_dumpall on the slave
C. Resume replication (by disabling the pause_at_recovery_target recovery target setting)During the pause, we would likely continue shipping WAL to the slave (unless this is unadvisable).
Is this a reasonable approach?
It will work... please read about the functions for pause/resume.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services