| From: | Andrew Hannon <ahannon(at)fiksu(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Two 9.1 Questions |
| Date: | 2011-09-12 15:52:37 |
| Message-ID: | B17124DA-4803-4393-B8F1-BFD4D04FA23E@fiksu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2011-09-12 16:19:12 | Re: Two 9.1 Questions |
| Previous Message | Thomas Kellerer | 2011-09-12 15:12:16 | Problem with the 9.1 one-click installer Windows7 64bit |