Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

From: "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl>
To: "John Gateley" <gateley(at)jriver(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>, "Bruno Wolff III" <bruno(at)wolff(dot)to>
Subject: Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Date: 2007-05-12 09:03:18
Message-ID: 73427AD314CC364C8DF0FFF9C4D693FF037B17@nehemiah.joris2k.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>-----Original Message-----
>From: pgsql-general-owner(at)postgresql(dot)org
>[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Bruno
>Wolff III
>Sent: vrijdag 11 mei 2007 21:18
>To: John Gateley
>Cc: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Fault Tolerant Postgresql (two
>machines, two postmasters, one disk array)
>
>On Thu, May 10, 2007 at 20:43:20 -0500,
> John Gateley <gateley(at)jriver(dot)com> wrote:
>> Sorry if this is a FAQ, I did search and couldn't find much.
>>
>> I need to make my Postgresql installation fault tolerant.
>> I was imagining a RAIDed disk array that is accessible from two (or
>> multiple) computers, with a postmaster running on each computer.
>> (Hardware upgrades could then be done to each computer at different
>> times without losing access to the database).
>>
>> Is this possible?
>
>You can't have two postmasters accessing the same data. Doing
>so will cause corruption. You can have a failover system where
>another postmaster starts after the normal one has stopped.
>But you need to be completely sure the normal postmaster has
>stopped before starting the backup one.

For this you might use heartbeat.
See http://www.linux-ha.org/

They seem to have a good tool to do the job. In general, version 1,
though limited to 2 nodes only is in use for several years and is will
supported with most linux distributions. Also a lot of information is
available on how to set up and getting it to work as desired.
The newer version 2 might provide more features than you actually need.
And since its newer there is fewer use.
I believe heartbeat is also one of the elements in redhats cluster
suite.

- Joris Dobbelsteen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-05-12 09:44:08 Re: Database transaction related
Previous Message Paul Lambert 2007-05-12 06:51:01 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)