Re: two postgres server seeing the same data

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: two postgres server seeing the same data
Date: 2008-12-03 18:10:29
Message-ID: 20081203181029.GG324@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote:
> You may have two servers pointed at $PGDATA but at no point can
> postgresql be running on both at the same time.

More importantly, if you do this, you will probably be able to get the
two postmasters to start up. This will permanently corrupt the data.
I know this partly because of experience with a "failover" system
whose interlocks failed. Two postmasters, one data area, and no
recoverable data.

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-12-03 18:16:58 Re: Switch off PITR
Previous Message Josh Harrison 2008-12-03 18:05:28 Re: Limit on number of databases in a Cluster ?