Re: BUG #15323: wal_keep_segments must be >= 1 for WAL archiving + streaming to work

From: Andres Freund <andres(at)anarazel(dot)de>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Phil Endecott <spam_from_pgsql_lists(at)chezphil(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15323: wal_keep_segments must be >= 1 for WAL archiving + streaming to work
Date: 2018-08-13 15:27:12
Message-ID: 20180813152712.u2jnag6jv7x5rkor@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018-08-13 11:22:11 -0400, Stephen Frost wrote:
> Greetings,
>
> * Andres Freund (andres(at)anarazel(dot)de) wrote:
> > On August 13, 2018 4:59:32 PM GMT+02:00, Phil Endecott <spam_from_pgsql_lists(at)chezphil(dot)org> wrote:
> > but in general, I think it's still
> > >possible
> > >that the master will remove the segment that is needed to start
> > >streaming.
> >
> > That's why I told you about replication slots....
>
> This should really work even without replication slots though.

Why? I fail to see what'd be gained by adding "always retain one
segment" rule. It'd not make the setup any more reliable. If anything
it'd make it harder to spot issues in test setups.

- Andres

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2018-08-13 15:42:47 Re: BUG #15323: wal_keep_segments must be >= 1 for WAL archiving + streaming to work
Previous Message Stephen Frost 2018-08-13 15:22:11 Re: BUG #15323: wal_keep_segments must be >= 1 for WAL archiving + streaming to work