Two 9.1 Questions
От | Andrew Hannon |
---|---|
Тема | Two 9.1 Questions |
Дата | |
Msg-id | B17124DA-4803-4393-B8F1-BFD4D04FA23E@fiksu.com обсуждение исходный текст |
Ответы |
Re: Two 9.1 Questions
|
Список | 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.0master? Are there any version differences that would cause a problem? We would then eventually promote the 9.1 machineto 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
В списке pgsql-general по дате отправления: