Re: Replication/Failover/HA solution

Ragnar Kjørstad wrote:

>On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote:
>
>
>>I am having a hard time selecting a Replication/Failover/HA solution for
>>PGSQL. What is troubling is the number of solutions available in various
>>states of development. Does the fact that dbmirror and rserv appear in
>>the contrib directory, mean that they should be looked upon with more
>>legitimacy? Any suggestions?
>>
>>
>
>One possibility is to run postgresql (regular postgresql - no patches
>required) controlled by heartbeat (http://www.linux-ha.org/) on two
>nodes. Heartbeat will then make sure that only one of the nodes are
>active at any time.
>
>You will have to put the databases on shared storage; either something
>like a shared SCSI RAID, or a software replication device like drdb or
>md+nbd.
>
I think it has been pointed out many times in the list
the running postgresql on a shared storage is dangerous.

Regds
Mallah.

>
>Make sure you have proper fencing in place, so you don't end up in a
>situation where both nodes are active and modifying your database.
>
>You should probably subscribe to the linux-ha mailinglist if you want to
>take this approach.
>
>
>
>
>