Re: Replication failed after stalling

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Joe Van Dyk <joe(at)tanga(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication failed after stalling
Date: 2013-12-18 20:51:35
Message-ID: 52B20AD7.6070005@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/18/2013 12:15 PM, Joe Van Dyk wrote:
> A possibly related question:
>
> I've set wal_keep_segments to 10,000 and also have archive_command
> running wal-e. I'm seeing my wal files disappear from pg_xlog after 30
> minutes. Is that expected? Is there a way around that?

Well a WAL segment is 16MB in size so that should give you a basis for
determining whether the above is appropriate, my guess it is not. I do
not know enough about Wal-e, but my guess is it is siphoning off WAL
segments before you want it to.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Abraham 2013-12-18 21:32:06 Re: Question(s) about crosstab
Previous Message Jerry Sievers 2013-12-18 20:33:05 Re: Replication failed after stalling