Re: advice on PGSQL cluster (active/passive)

From: FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA>
To: Devrim GUNDUZ <devrim(at)commandprompt(dot)com>
Cc: Mailing List Postgresql <pgsql-admin(at)postgresql(dot)org>
Subject: Re: advice on PGSQL cluster (active/passive)
Date: 2006-04-11 14:52:56
Message-ID: 443BC2C8.10407@lexum.umontreal.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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,

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-04-11 15:27:10 Re: advice on PGSQL cluster (active/passive)
Previous Message Devrim GUNDUZ 2006-04-11 14:20:26 Re: advice on PGSQL cluster (active/passive)