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

From Florian G. Pflug
Subject Re: Shared pg_xlog directory/partition and warm standby
Date
Msg-id 456AE578.6010807@phlo.org
Whole thread Raw
In response to Shared pg_xlog directory/partition and warm standby server  (Devrim GUNDUZ <devrim@CommandPrompt.com>)
Responses Re: Shared pg_xlog directory/partition and warm standby  ("Simon Riggs" <simon@2ndquadrant.com>)
Re: Shared pg_xlog directory/partition and warm standby  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Devrim GUNDUZ wrote:
> Hello,
> 
> 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? The problem is: If we
> share the same pg_xlog between production server and warm standby
> server; can you see any possibility of data/xlog corruption? Of course,
> warm standby server will mount that partition as read-only.

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

AFAIK the files in pg_xlog form a circular buffer, and are reused after 
a while...

greetings, Florian Pflug


pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: "Optional ident" authentication
Next
From: Alvaro Herrera
Date:
Subject: Re: Integrating Replication into Core