Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 501EB9F9946 for ; Sun, 7 Oct 2007 22:43:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 21643-01 for ; Sun, 7 Oct 2007 22:42:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 222A79F9944 for ; Sun, 7 Oct 2007 22:43:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l981grrA026061; Sun, 7 Oct 2007 21:42:53 -0400 (EDT) To: "Faber J. Fedor" cc: pgsql-admin@postgresql.org Subject: Re: Warm/hot backup server question In-reply-to: <20071007202255.GB30292@neptune.faber.nom> References: <20071007202255.GB30292@neptune.faber.nom> Comments: In-reply-to "Faber J. Fedor" message dated "Sun, 07 Oct 2007 16:22:55 -0400" Date: Sun, 07 Oct 2007 21:42:53 -0400 Message-ID: <26060.1191807773@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/41 X-Sequence-Number: 26955 "Faber J. Fedor" writes: > I've been given the job of creating a hot/warm backup server > for a live Postgresql server. The problem is two-fold: 1) it's version > 7.4.9 and an upgrade is not feasible at this time and b) there are > multiple instances of postgresql running on the box; not multiple > databases, multiple *servers*, each listening on a different port (it > was a business requirement from what I've been told). If they won't let you update to 7.4.18 (the current release in that branch), you would be best advised to resign at once, before you get blamed for the train wreck that is inevitably in this system's future. 7.4.9 is two years old, and I count at least six fixes since then for data-loss bugs of the *will*-bite-you-eventually type; plus a couple more that you might be at risk for depending on which features you use. Also, the choice to run separate servers sounds a whole lot like they are serving clients that they don't trust 100%, which means there are also half a dozen security fixes that they should be worried about. > Can 7.4 do the same magic as 8.2 wrt to WAL? No. Slony is your best bet --- not least because it may simplify a live upgrade to a newer version. regards, tom lane