Search Postgresql Archives

Re: two postgres server seeing the same data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux