Adding Additional Standby
От | Andrew Hannon |
---|---|
Тема | Adding Additional Standby |
Дата | |
Msg-id | 1FC679A3-966A-4C7D-B1F3-52E9A3264240@fiksu.com обсуждение исходный текст |
Ответы |
Re: Adding Additional Standby
|
Список | pgsql-general |
Hello, We have an existing master-slave setup running on 9.0. I was looking into adding a new hot standby into this setup — I haveadded a script that satisfies the requirements of the archive_command, but it isn't clear to me how to add this new standbyinto the mix. Is it as simple as calling pg_start_backup to create a new base backup and then starting postgresqlon the new machine once the base backup has completed? Aren't there syncing issues to consider? My intuition tellsme that the standbys need to be in sync for the archive_command to work (since it simply passes in a filename that isexpected to get copied over). Initially, I was planning on pausing replication on the existing standby, and running replication on the new stanby to catchup to the same xid as the old standby. However, I then discovered that pausing isn't supported on 9.0 (but will be on9.1). Does stopping postgresql on the existing standby have the same effect? Am I doing something unusual here? Is it possibleto do what I am attempting to do? Thank you very much! Andrew
В списке pgsql-general по дате отправления: