agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Amit Kapila <akapila@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Doc: Clarify DROP SUBSCRIPTION behavior after SET (slot_name = N
Date: Fri, 17 Jul 2026 04:25:18 +0000
Message-ID: <E1wka8T-000ZDA-2D@gemulon.postgresql.org> (raw)
Doc: Clarify DROP SUBSCRIPTION behavior after SET (slot_name = NONE).
The previous text claimed that once the slot is disassociated with
ALTER SUBSCRIPTION ... SET (slot_name = NONE), DROP SUBSCRIPTION "will no
longer attempt any actions on a remote host". That is inaccurate:
DROP SUBSCRIPTION may still connect to the publisher to drop
internally-created table synchronization slots when some table
synchronization is left unfinished. Reword to describe this, and note
that if the publisher is unreachable those slots (and the main slot, if
it still exists) must be dropped manually to avoid indefinitely reserving
WAL.
Reported-by: Jeff Davis <pgsql@j-davis.com>
Author: Amit Kapila <amit.kapila16@gmail.com>
Backpatch-through: 14
Discussion: https://postgr.es/m/CAA4eK1+tyYSpPxMBy1974kjivuGeR7YY=yopwRGrK3+vCTysdg@mail.gmail.com
Discussion: https://postgr.es/m/D908370F-2695-4231-851D-17179A6A6F2A@gmail.com
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/d7b62e3c22102898a6106baa129a2e6b838b4bc1
Modified Files
--------------
doc/src/sgml/ref/drop_subscription.sgml | 14 ++++++++------
1 file changed, 8 insertions(+), 6 deletions(-)
view thread (7+ messages)
Message-ID: <E1wka8T-000ZDA-2D@gemulon.postgresql.org>
Permalink: ../E1wka8T-000ZDA-2D@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wka8T-000ZDA-2D@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: akapila@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Doc: Clarify DROP SUBSCRIPTION behavior after SET (slot_name = N
In-Reply-To: <E1wka8T-000ZDA-2D@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox