diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-05-31 22:35:33 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-06-02 15:16:57 -0400 |
| commit | de492c17f064ea3ddcb73d9529f3e30a1483ffa5 (patch) | |
| tree | 78f04c83382c63290fb7ba2a5376c04a053d26a5 | |
| parent | 420a0392ef8fdac3eb6f0a616c136215f7454674 (diff) | |
| download | postgresql-de492c17f064ea3ddcb73d9529f3e30a1483ffa5.tar.gz postgresql-de492c17f064ea3ddcb73d9529f3e30a1483ffa5.zip | |
doc: Add note that DROP SUBSCRIPTION drops replication slot
Add some information about what to do when this fails.
| -rw-r--r-- | doc/src/sgml/ref/drop_subscription.sgml | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml index 4f34a35eefe..42068d617bc 100644 --- a/doc/src/sgml/ref/drop_subscription.sgml +++ b/doc/src/sgml/ref/drop_subscription.sgml @@ -74,6 +74,28 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable </refsect1> <refsect1> + <title>Notes</title> + + <para> + When dropping a subscription that is associated with a replication slot on + the remote host (the normal state), <command>DROP SUBSCRIPTION</command> + will connect to the remote host and try to drop the replication slot as + part of its operation. This is necessary so that the resources allocated + for the subscription on the remote host are released. If this fails, + either because the remote host is not reachable or because the remote + replication slot cannot be dropped or does not exist or never existed, + the <command>DROP SUBSCRIPTION</command> command will fail. To proceed in + this situation, disassociate the subscription from the replication slot by + executing <literal>ALTER SUBSCRIPTION ... SET (slot_name = NONE)</literal>. + After that, <command>DROP SUBSCRIPTION</command> will no longer attempt any + actions on a remote host. Note that if the remote replication slot still + exists, it should then be dropped manually; otherwise it will continue to + reserve WAL and might eventually cause the disk to fill up. See + also <xref linkend="logical-replication-subscription-slot">. + </para> + </refsect1> + + <refsect1> <title>Examples</title> <para> |