Re: Adding Additional Standby

Andrew Hannon <ahannon(at)fiksu(dot)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°