X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9AE9632A014 for ; Mon, 4 Oct 2004 19:49:12 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17447-02 for ; Mon, 4 Oct 2004 18:49:07 +0000 (GMT) Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by svr1.postgresql.org (Postfix) with ESMTP id EDE2F329FB3 for ; Mon, 4 Oct 2004 19:49:07 +0100 (BST) Received: from [198.212.166.61] (Voyager.turbocorp.com [198.212.166.61]) by Mercury.turbocorp.com (8.12.8/8.12.8) with ESMTP id i94In46C021712 for ; Mon, 4 Oct 2004 14:49:05 -0400 Message-ID: <41619B28.5010707@turbocorp.com> Date: Mon, 04 Oct 2004 14:49:12 -0400 From: John Allgood User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Failover Solution for Postgres Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Turbo-MailScanner-Information: Please contact the ISP for more information X-Turbo-MailScanner: Found to be clean X-Turbo-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=0.111, required 6, RATWR10_MESSID 0.11) X-MailScanner-From: john@turbocorp.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/85 X-Sequence-Number: 15078 Hello All I am looking for information on postgres failover solutions. I have researched Dbmirror, DBcluster, and GFS along with others. This server is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am trying to get an idea of what is stable and reliable. What are people on this list running for you failover solutions and what recommendations can you give me. The server will be running about 9 databases anywhere form 350MB to 3GB. Looking to go live on the system 1st quarter 2005. I would love to wait until postgres 8.0 is released and get the point-in-time recovery along with the other features that will be in that version. But that will have to wait. Thanks -- John Allgood - ESC Systems Administrator 678.989.3051