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

From hubert depesz lubaczewski
Subject Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!
Date
Msg-id 20130712110536.GA471@depesz.com
Whole thread Raw
In response to Re: How can you get "WAL segment has already been removed" when doing synchronous replication ?!  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-general
On Fri, Jul 12, 2013 at 12:30:22PM +0530, Amit Langote wrote:
> >> Increasing the wal_keep_segments ?
> > I know that I can increase wal_keep_segments to "solve" it, but
> > shouldn't it be *impossible* to happen with synchronous replication?
> > After all - all commits should wait for slave to be 100% up to date!
> Is it possible that xlog recycling might have caused this wherein the
> xlog segment which is yet to be archived/shipped is recycled? I

As far as I know, pg will not recycle log before it's archived.
Otherwise we wouldn't be able to have archives.

> remember something of that sort. Check this discussion:
> http://www.postgresql.org/message-id/51779B3B.1020003@lab.ntt.co.jp
> Is this logged on the master or a standby?

master.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/


pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: function returning select result to JDBC
Next
From: Vincenzo Romano
Date:
Subject: