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. 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. -- Ragnar Kjorstad ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
