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

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