Re: Shared pg_xlog directory/partition and warm standby - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Shared pg_xlog directory/partition and warm standby
Date
Msg-id 21880.1164653639@sss.pgh.pa.us
Whole thread Raw
In response to Re: Shared pg_xlog directory/partition and warm standby  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
"Florian G. Pflug" <fgp@phlo.org> writes:
> Devrim GUNDUZ wrote:
>> Is there anything that may prevent two PostgreSQL servers to share the
>> same pg_xlog directory; while one is using read-only and the other one
>> is using the same partition for read and write?

> What happens in the standby server falls so far behind the master that
> the xlogs it wants to read are already being overwritten?

Worse than that: what happens when the standby comes alive, and needs to
start writing pg_xlog entries?

Sounds like a disaster in the making to me.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Next
From: Hannu Krosing
Date:
Subject: Re: Integrating Replication into Core