@@ -73,6 +73,28 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable
7373 </variablelist>
7474 </refsect1>
7575
76+ <refsect1>
77+ <title>Notes</title>
78+
79+ <para>
80+ When dropping a subscription that is associated with a replication slot on
81+ the remote host (the normal state), <command>DROP SUBSCRIPTION</command>
82+ will connect to the remote host and try to drop the replication slot as
83+ part of its operation. This is necessary so that the resources allocated
84+ for the subscription on the remote host are released. If this fails,
85+ either because the remote host is not reachable or because the remote
86+ replication slot cannot be dropped or does not exist or never existed,
87+ the <command>DROP SUBSCRIPTION</command> command will fail. To proceed in
88+ this situation, disassociate the subscription from the replication slot by
89+ executing <literal>ALTER SUBSCRIPTION ... SET (slot_name = NONE)</literal>.
90+ After that, <command>DROP SUBSCRIPTION</command> will no longer attempt any
91+ actions on a remote host. Note that if the remote replication slot still
92+ exists, it should then be dropped manually; otherwise it will continue to
93+ reserve WAL and might eventually cause the disk to fill up. See
94+ also <xref linkend="logical-replication-subscription-slot">.
95+ </para>
96+ </refsect1>
97+
7698 <refsect1>
7799 <title>Examples</title>
78100