Re: BUG #15959: 'DROP EXTENSION pglogical' while an unused logicalreplication slot exists causes slot corruption - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #15959: 'DROP EXTENSION pglogical' while an unused logicalreplication slot exists causes slot corruption
Date
Msg-id 02366a7a-ffee-d0b3-80e3-d291b44693ce@2ndquadrant.com
Whole thread Raw
In response to BUG #15959: 'DROP EXTENSION pglogical' while an unused logical replication slot exists causes slot corruption  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15959: 'DROP EXTENSION pglogical' while an unused logicalreplication slot exists causes slot corruption  (Matt Wise <wise@wiredgeek.net>)
List pgsql-bugs
On 2019-08-14 23:35, PG Bug reporting form wrote:
> Short Description:
>   If you have a logical replication slot created (but not being actively
> consumed from) and you issue a 'DROP EXTENSION pglogical', it puts the
> database into a bad state. Later when the consumer for that slot comes in
> and tries to start replicating they will receive the following error:
> 
>   pg_recvlogical: unexpected termination of replication stream: ERROR: 
> could not find pg_class entry for 16387
> 
> Detailed Setup:
>   To replicate the issue fully, check out the code at
> https://github.com/diranged/postgres-logical-replication-pgclass-bug and
> follow the instructions.

What version of pglogical are you using?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-bugs by date:

Previous
From: "Bansal, Abhishek (Abhishek)"
Date:
Subject: Postgresql Query
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #15961: psql should be able to read password from stdin