Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7BB889F98C0 for ; Sun, 7 Oct 2007 17:23:10 -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 22732-05 for ; Sun, 7 Oct 2007 17:22:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.linuxnj.com (sedna.linuxnj.com [66.187.137.76]) by postgresql.org (Postfix) with ESMTP id AF5B89F95DC for ; Sun, 7 Oct 2007 17:23:02 -0300 (ADT) Received: from neptune.faber.nom (c-68-36-18-184.hsd1.nj.comcast.net [68.36.18.184]) by mail.linuxnj.com (Postfix) with ESMTP id F03F31C323B for ; Sun, 7 Oct 2007 20:20:48 +0000 (UTC) Received: by neptune.faber.nom (Postfix, from userid 500) id ED710B3E59; Sun, 7 Oct 2007 16:22:55 -0400 (EDT) Date: Sun, 7 Oct 2007 16:22:55 -0400 From: "Faber J. Fedor" To: pgsql-admin@postgresql.org Subject: Warm/hot backup server question Message-ID: <20071007202255.GB30292@neptune.faber.nom> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.2i X-LinuxNJ-MailScanner-Information: Please contact the ISP for more information X-LinuxNJ-MailScanner: Found to be clean X-LinuxNJ-MailScanner-From: faber@linuxnj.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/37 X-Sequence-Number: 26951 Hi, 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). I plan on using heartbeat and mon to monitor the primary server for non-availability and fail over. I thought about DRBD, but that would require repartitioning the live server and I want to touch it as little as possible. I've read the docs for WAL and the 8.2 version sounds perfect for what I want but, as I said, an upgrade is out of the question for now. I see that 7.4 has WAL, but I didn't see mention of the warm backups as mentioned in the 8.2 docs. Can 7.4 do the same magic as 8.2 wrt to WAL? Is SLONY/replication my only choice? Remember, I can't/don't want to rebuild the existing servers. TIA! -- Regards, Faber Fedor President Linux New Jersey, Inc. 908-320-0357 800-706-0701 http://www.linuxnj.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.