Re: 2 instance of postgres service running against same db files?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/25/07 12:59, Raymond O'Donnell wrote:
> On 25/05/2007 18:56, Arnaldo Gandol wrote:
>
>> Can I have 2 instance of postgres service running against same db???. I
>> meant 2 machine or the same machine with a 2 running executing postgres
>> process (if it is in the same machine, then through different ports),
>
> AFAIK you can't, and trying to do so is a sure way to finish up with a
> corrupt database.

It sure would be nice, but would require (lots of?) work in order to
integrate PG with a distributed lock manager. And *BSD don't have
one, although a DLM was merged into Linux 2.6.19.

http://en.wikipedia.org/wiki/Distributed_lock_manager
http://sources.redhat.com/cluster/dlm/

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

iD8DBQFGVy3vS9HxQb37XmcRAqAhAJ0dZrydsclLG2SC8CiEwofIsatx6gCgupqV
gMbKrKWH7ZP07E5MHVMa68s=
=+nrW
-----END PGP SIGNATURE-----