Andrew Hannon <ahannon@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
