Horton
Menu

Thread

  1. 2 instance of postgres service running against same db files?

    Arnaldo Gandol <agacode@gmail.com> — 2007-05-25T17:56:19Z

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

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

    Raymond O'Donnell <rod@iol.ie> — 2007-05-25T17:59:34Z

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

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

    John Gateley <gateley@jriver.com> — 2007-05-25T18:05:32Z

    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.

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

    Ron Johnson <ron.l.johnson@cox.net> — 2007-05-25T18:41:51Z

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