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

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