Re: WAL recycled despite logical replication slot

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: WAL recycled despite logical replication slot
Дата
Msg-id 20190922233739.ayo7egos7losgatn@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: WAL recycled despite logical replication slot  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: JSONPATH documentation
Следующее
От: Andres Freund
Дата:
Сообщение: Re: strong memory leak in plpgsql from handled rollback and lazy cast