DROP SUBSCRIPTION with no slot - Mailing list pgsql-hackers

From Jeff Janes
Subject DROP SUBSCRIPTION with no slot
Date
Msg-id CAMkU=1zOWyYzNCzNLN9MvqnnrVGXZfTNe1dZ0Gh+6XkT8d8X2Q@mail.gmail.com
Whole thread Raw
Responses Re: DROP SUBSCRIPTION with no slot
List pgsql-hackers
I recently had to cut loose (pg_drop_replication_slot) a logical replica that couldn't keep up and so was threatening to bring down the master.

In mopping up on the replica side, I couldn't just drop the subscription, because it couldn't drop the nonexistent slot on the master and so refused to work.  So I had to do a silly little dance where I first disable the subscription, then ALTER SUBSCRIPTION ... SET (slot_name = NONE), then drop it.

Wanting to clean up after itself is admirable, but if there is nothing to clean up, why should that be an error condition?  Should this be an item on https://wiki.postgresql.org/wiki/Todo (to whatever extent that is still used).

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Nikolay Shaplov
Date:
Subject: Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method
Next
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL12 and older versions of OpenSSL