| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | PostgreSQL - General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?! |
| Date: | 2013-07-11 17:59:24 |
| Message-ID: | CA+h6Ahj-16fC9wdOMei+c8xO8sdEW7vk2aoLYbLaqYEBZA6HLg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jul 11, 2013 at 11:18 PM, hubert depesz lubaczewski <
depesz(at)depesz(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2013-07-11 18:01:03 | Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?! |
| Previous Message | hubert depesz lubaczewski | 2013-07-11 17:48:43 | How can you get "WAL segment has already been removed" when doing synchronous replication ?! |