X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1667511F697B for ; Tue, 11 Apr 2006 11:20:39 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 6KrNRL03-RbD for ; Tue, 11 Apr 2006 11:20:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 0037711F6C20 for ; Tue, 11 Apr 2006 11:20:13 -0300 (ADT) Received: from [192.168.1.30] ([212.156.230.146]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k3BEJtWI015119; Tue, 11 Apr 2006 07:19:57 -0700 Subject: Re: advice on PGSQL cluster (active/passive) From: Devrim GUNDUZ To: FM Cc: Mailing List Postgresql In-Reply-To: <443B9D0F.6010200@lexum.umontreal.ca> References: <443B9D0F.6010200@lexum.umontreal.ca> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Tue, 11 Apr 2006 17:20:26 +0300 Message-Id: <1144765226.4096.3.camel@laptop.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.6.0 (2.6.0-1) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Tue, 11 Apr 2006 07:19:59 -0700 (PDT) X-Archive-Number: 200604/100 X-Sequence-Number: 21269 Hi, On Tue, 2006-04-11 at 08:11 -0400, FM wrote: > Next month I will receive my SAN and a new server. Using Redhat > Cluster Suite + GFS, I'd like to create a PGSQL active/passive > cluster. > Do you have some advice about this setup or advice for PGSQL > Clustering ? I've tried this configuration last month. You have to be sure that the active node is really down; and before bringing up the active node back again, be sure to stop postmaster on the passive node to avoid data loss problems. You need to configure the cluster.conf so that it uses any fence device; otherwise your nodes may fail randomly. I can't remember any special problems right now; but if I do I'll post to the list. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/