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