Обсуждение: advice on PGSQL cluster (active/passive)
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 !
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/
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,
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/