How can you get "WAL segment has already been removed" when doing synchronous replication ?!

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Дата
Msg-id 20130711174842.GA16929@depesz.com
обсуждение исходный текст
Ответы Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Список pgsql-general
We are seeing situation like this:
1. 9.2.4 database
2. Master settings:
           name            |    setting
---------------------------+---------------
 fsync                     | on
 synchronize_seqscans      | on
 synchronous_commit        | remote_write
 synchronous_standby_names | *
 wal_sync_method           | open_datasync
(5 rows)

Yet, every now and then we're getting:
FATAL:  requested WAL segment * has already been removed

Assuming no part of the system is issuing "set synchronous_commit
= off", how can we get in such situation?

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/


В списке pgsql-general по дате отправления:

Предыдущее
От: Raghavendra
Дата:
Сообщение: Re: Reply: [GENERAL] 回复: [GENERAL] Can't create plpython language
Следующее
От: Raghavendra
Дата:
Сообщение: Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!