pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
advice on PGSQL cluster (active/passive)
4+ messages / 2 participants
[nested] [flat]

* advice on PGSQL cluster (active/passive)
@ 2006-04-11 12:11 FM <dist-list@LEXUM.UMontreal.CA>
  2006-04-11 14:20 ` Re: advice on PGSQL cluster (active/passive) Devrim GUNDUZ <devrim@commandprompt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: FM @ 2006-04-11 12:11 UTC (permalink / raw)
  To: pgsql-admin

Hello,
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 ?
For now, we are using 7.4.x but we will migrate to 8.1.x

My passive server will be a VMWare Virtual host with the same amount of 
memory then the active  node.

Thanks !



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: advice on PGSQL cluster (active/passive)
  2006-04-11 12:11 advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
@ 2006-04-11 14:20 ` Devrim GUNDUZ <devrim@commandprompt.com>
  2006-04-11 14:52   ` Re: advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
  0 siblings, 1 reply; 4+ messages in thread

From: Devrim GUNDUZ @ 2006-04-11 14:20 UTC (permalink / raw)
  To: FM <dist-list@LEXUM.UMontreal.CA>; +Cc: pgsql-admin

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/




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: advice on PGSQL cluster (active/passive)
  2006-04-11 12:11 advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
  2006-04-11 14:20 ` Re: advice on PGSQL cluster (active/passive) Devrim GUNDUZ <devrim@commandprompt.com>
@ 2006-04-11 14:52   ` FM <dist-list@LEXUM.UMontreal.CA>
  2006-04-11 15:27     ` Re: advice on PGSQL cluster (active/passive) Devrim GUNDUZ <devrim@commandprompt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: FM @ 2006-04-11 14:52 UTC (permalink / raw)
  To: Devrim GUNDUZ <devrim@commandprompt.com>; +Cc: 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,



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: advice on PGSQL cluster (active/passive)
  2006-04-11 12:11 advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
  2006-04-11 14:20 ` Re: advice on PGSQL cluster (active/passive) Devrim GUNDUZ <devrim@commandprompt.com>
  2006-04-11 14:52   ` Re: advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
@ 2006-04-11 15:27     ` Devrim GUNDUZ <devrim@commandprompt.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Devrim GUNDUZ @ 2006-04-11 15:27 UTC (permalink / raw)
  To: FM <dist-list@LEXUM.UMontreal.CA>; +Cc: pgsql-admin


Hi,

On Tue, 2006-04-11 at 10:52 -0400, FM wrote:
> 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 

My experiences show that many people forget to configure the fence
device in their Cluster configurations. That's why I said so. (This is
offtopic for this list, but I wanted to write)

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/




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-04-11 15:27 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-11 12:11 advice on PGSQL cluster (active/passive) FM <dist-list@LEXUM.UMontreal.CA>
2006-04-11 14:20 ` Devrim GUNDUZ <devrim@commandprompt.com>
2006-04-11 14:52   ` FM <dist-list@LEXUM.UMontreal.CA>
2006-04-11 15:27     ` Devrim GUNDUZ <devrim@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox