On Thu, Jul 11, 2013 at 11:18 PM, hubert depesz lubaczewski <
dep...@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
Blog: http://raghavt.blogspot.com/

Reply via email to