Re: WAL recycled despite logical replication slot - Mailing list pgsql-hackers

From Andres Freund
Subject Re: WAL recycled despite logical replication slot
Date
Msg-id 20190922233739.ayo7egos7losgatn@alap3.anarazel.de
Whole thread Raw
In response to Re: WAL recycled despite logical replication slot  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Hi,

On 2019-09-22 11:45:05 -0400, Jeff Janes wrote:
> On Fri, Sep 20, 2019 at 6:25 PM Andres Freund <andres@anarazel.de> wrote:
> > Hi,
> > >Is there an innocent explanation for this?  I thought logical
> > >replication
> > >slots provided an iron-clad guarantee that WAL would be retained until
> > >it
> > >was no longer needed.  I am just using pub/sub, none of the lower level
> > >stuff.
> >
> > It indeed should. What's the content of
> > pg_replication_slot for that slot?
> >
> 
> Unfortunately I don't think I have that preserved.  If I can reproduce the
> issue, would preserving data/pg_replslot/sub/state help as well?

Can't hurt. Best together with other slots, if they exists.

Could you describe the system a bit?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: JSONPATH documentation
Next
From: Andres Freund
Date:
Subject: Re: strong memory leak in plpgsql from handled rollback and lazy cast