Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse
Date
Msg-id 87vb0ja0b5.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse
List pgsql-bugs
>>>>> "Michael" == Michael Paquier <michael.paquier@gmail.com> writes:

 >> When creating a physical replication slot, the catalog_xmin field of
 >> the new slot is not initialized. If the slot storage had previously
 >> been used for a logical slot, the old catalog_xmin will remain in
 >> place and interfere with vacuum.

 Michael> Good catch! The same applies to confirmed_flush_lsn, which is
 Michael> used only by logical decoding and should remain as NULL for
 Michael> physical slots.  So I propose the patch attached to address
 Michael> both problems.

What about slot->effective_catalog_xmin ?

--
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse
Next
From: Michael Paquier
Date:
Subject: Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse