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