Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 43BC79F9946 for ; Mon, 8 Oct 2007 00:07:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 97287-03 for ; Mon, 8 Oct 2007 00:07:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 2D9159F97E5 for ; Mon, 8 Oct 2007 00:07:02 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so775680ugf for ; Sun, 07 Oct 2007 20:07:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ORoyvsH2oI3ymscGjWY8h+QYHCsNQojptz6UIixKpcU=; b=hyQfxeJuBtM7ERYY+7lJj3aDNcH1f9Pbt1yb6c5V1n0duA5g6N7jQWdfs0hSJ1ET3y2oL6wFCE68in2YuXxydCMTLIvlKaAp2ZotELDqMPsMQ25VkFeDeN9SHRzQssvOGUgqddLgx/K0Mb+Xm+MEBbmfeSyqwCoZECqZyOAXbFc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=uLQsTjnc+GG9KCPd+Y6ioi9iORAl/ziINAI1XdRhINaOw5cbAaKYLWZk6fIyL82EJ3jw2VLwxQkFeUWWSHKt++U5nc8nnR5ER3sQbK6/5kq8gTDecwAP85XBuCMcHZApNIA08IQasbL2XBkS3TO7Jr0wxzUt/cWw9uvxfo3djYU= Received: by 10.67.19.13 with SMTP id w13mr6333826ugi.1191812820904; Sun, 07 Oct 2007 20:07:00 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Sun, 7 Oct 2007 20:07:00 -0700 (PDT) Message-ID: Date: Sun, 7 Oct 2007 22:07:00 -0500 From: "Scott Marlowe" To: "Tom Lane" Subject: Re: Warm/hot backup server question Cc: "Faber J. Fedor" , pgsql-admin@postgresql.org In-Reply-To: <26060.1191807773@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071007202255.GB30292@neptune.faber.nom> <26060.1191807773@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/44 X-Sequence-Number: 26958 On 10/7/07, Tom Lane wrote: > "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. I agree. Although I'd set up your new job first if possible. I also agree that Slony is your best bet. Note only the older versions of slony run on 7.4, so make sure you download the version of slony that works with 7.4. I think it's 1.0, could be 1.1 or so.