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.
---------------------------(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
