Re: advice on PGSQL cluster (active/passive)

Поиск
Список
Период
Сортировка
От Devrim GUNDUZ
Тема Re: advice on PGSQL cluster (active/passive)
Дата
Msg-id 1144765226.4096.3.camel@laptop.gunduz.org
обсуждение исходный текст
Ответ на advice on PGSQL cluster (active/passive)  (FM <dist-list@LEXUM.UMontreal.CA>)
Ответы Re: advice on PGSQL cluster (active/passive)
Список 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/


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Bruno G. Albuquerque"
Дата:
Сообщение: Large scale PostgreSQL deployment.
Следующее
От: FM
Дата:
Сообщение: Re: advice on PGSQL cluster (active/passive)