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

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Дата
Msg-id CA+h6Ahj-16fC9wdOMei+c8xO8sdEW7vk2aoLYbLaqYEBZA6HLg@mail.gmail.com
обсуждение исходный текст
Ответ на How can you get "WAL segment has already been removed" when doing synchronous replication ?!  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Дерево обсуждения

On Thu, Jul 11, 2013 at 11:18 PM, hubert depesz lubaczewski <depesz@depesz.com> wrote:
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


Increasing the wal_keep_segments ?

---
Regards,
Raghavendra
EnterpriseDB Corporation

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!