pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedadvice 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>
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 14:20 Devrim GUNDUZ <devrim@commandprompt.com>
parent: 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 14:52 FM <dist-list@LEXUM.UMontreal.CA>
parent: 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 15:27 Devrim GUNDUZ <devrim@commandprompt.com>
parent: FM <dist-list@LEXUM.UMontreal.CA>
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