""Nigel Bishop"" <Nigel(dot)Bishop(at)ioko(dot)com> wrote
> I'm investigating the use of a second server with a backup copy of the
> live DB set up and in recovery mode.
You may want to check out the Slony I project:
http://gborg.postgresql.org/index.php
BTW, if you want "cold" standby (means if one server crashed, the other will
replay the WAL xlogs(takes seconds or hours, depends how much work needed to
be redo), and startup and take the job), then there is a much easier
solution of connect two machines on a shared-disk array.
Regards,
Qingqing