Andrew Hannon <ahan...@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° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general