Re: Shared pg_xlog directory/partition and warm standby

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Shared pg_xlog directory/partition and warm standby
Дата
Msg-id 21880.1164653639@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Shared pg_xlog directory/partition and warm standby  ("Florian G. Pflug" <fgp@phlo.org>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Integrating Replication into Core