Postgres Pro
Downloads
Home   >   mailing lists

Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?! - Mailing list pgsql-general

From Raghavendra
Subject Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Date
Msg-id CA+h6Ahj-16fC9wdOMei+c8xO8sdEW7vk2aoLYbLaqYEBZA6HLg@mail.gmail.com
Whole thread Raw
In response to How can you get "WAL segment has already been removed" when doing synchronous replication ?!  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
List pgsql-general
Tree view

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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!