-----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----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
