Postgres Pro
Downloads
Home   >   mailing lists

Re: two postgres server seeing the same data - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: two postgres server seeing the same data
Date
Msg-id 20081203181029.GG324@shinkuro.com
Whole thread Raw
In response to Re: two postgres server seeing the same data  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: two postgres server seeing the same data  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
List pgsql-general
Tree view 
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@crankycanuck.ca

pgsql-general by date:

Previous
From: "Josh Harrison"
Date:
Subject: Re: Limit on number of databases in a Cluster ?
Next
From: Bill Moran
Date:
Subject: Re: Switch off PITR