2 instance of postgres service running against same db files?
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),
working with the same db files, may be in a shared storage or any common
mounted file system. Any other variant? How?
Im sorry because of my english. I speak spanish.
thanks...
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.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------
Take a search through the archives for:
Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
I recently posted this question and got a lot of good responses.
j
On Fri, 25 May 2007 18:59:34 +0100
Raymond O'Donnell <rod@iol.ie> wrote:
Show quoted text
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.
-----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-----