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 1FC9411F7B64 for ; Tue, 11 Apr 2006 11:53:26 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.479 X-Spam-Level: X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id zqdUs0Cae5IN for ; Tue, 11 Apr 2006 11:52:59 -0300 (ADT) X-Greylist: delayed 02:40:55.454986 by SQLgrey- Received: from chene.DIT.UMontreal.CA (chene.DIT.UMontreal.CA [132.204.246.20]) by postgresql.org (Postfix) with ESMTP id 6D64911F70D8 for ; Tue, 11 Apr 2006 11:52:58 -0300 (ADT) Received: from mail.lexum.umontreal.ca (gw-mail.LEXUM.UMontreal.CA [132.204.136.52]) by chene.DIT.UMontreal.CA (8.13.6/8.13.6) with ESMTP id k3BEqvSm011717 for ; Tue, 11 Apr 2006 10:52:57 -0400 Received: from [192.168.4.171] ([::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, SSL: TLSv1/SSLv3,256bits,AES256-SHA) by mail.lexum.umontreal.ca with esmtp; Tue, 11 Apr 2006 10:52:19 -0400 id 00013876.443BC2A3.00006CD3 Message-ID: <443BC2C8.10407@lexum.umontreal.ca> Date: Tue, 11 Apr 2006 10:52:56 -0400 From: FM User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Devrim GUNDUZ CC: Mailing List Postgresql Subject: Re: advice on PGSQL cluster (active/passive) References: <443B9D0F.6010200@lexum.umontreal.ca> <1144765226.4096.3.camel@laptop.gunduz.org> In-Reply-To: <1144765226.4096.3.camel@laptop.gunduz.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: -2.5 X-NAI-Spam-Rules: 1 Rules triggered BAYES_00=-2.5 X-Archive-Number: 200604/101 X-Sequence-Number: 21270 Thanks for the response, What do you mean by " You need to configure the cluster.conf so that it uses any fence device otherwise your nodes may fail randomly." FYI : I'll use my APC symetra as my fencing device thank you ! Devrim GUNDUZ wrote: > 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,