""Nigel Bishop"" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
