-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/10/07 20:43, John Gateley 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? > > Is there another way to do this I should be looking at?
PostgreSQL does not have a Distributed Lock Manager, so the two postmasters could not coordinate locking and updating. *Maybe* it would work if you put your data on to of OCFS2 filesystems, but I doubt it. Of course, you could always run OpenVMS. You can get *big*, used Alphas for a song. The yearly software licensing fees would be pretty steep, though. http://en.wikipedia.org/wiki/VMScluster http://en.wikipedia.org/wiki/Distributed_lock_manager - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGQ9u5S9HxQb37XmcRAhyyAKCWghW9kN+yttTndbRmvvTJY9n0vQCfdt60 C/oVMevsTtMt6SGCBSWZHAU= =hesp -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
