""Nigel Bishop"" <Nigel.Bishop@xxxxxxxx> 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
