Re: Adding Additional Standby
От | Andreas Kretschmer |
---|---|
Тема | Re: Adding Additional Standby |
Дата | |
Msg-id | 20110903163045.GA12956@tux обсуждение исходный текст |
Ответ на | Adding Additional Standby (Andrew Hannon <ahannon@fiksu.com>) |
Список | pgsql-general |
Andrew Hannon <ahannon@fiksu.com> wrote: > 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 have added a script > that satisfies the requirements of the archive_command, but it isn't > clear to me how to add this new standby into the mix. Is it as simple > as calling pg_start_backup to create a new base backup and then > starting postgresql on the new machine once the base backup has > completed? Yes, that's all. You should increase max_wal_senders (on the server) to (count of clients) + reserve (maybe 3 or so) And you need a propper recovery.conf on the new client. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: