diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-28 10:05:21 -0400 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-28 10:05:21 -0400 |
| commit | ff539da31691f2cd2694360250571c5c5fb7415e (patch) | |
| tree | 494ffccc465ca33af0efd5dc764a169c66fb4bc1 /doc/src | |
| parent | 4d33a7f2e714848ca7b5b7ef8e244eead078ca13 (diff) | |
Cleanup slots during drop database
Automatically drop all logical replication slots associated with a
database when the database is dropped. Previously we threw an ERROR
if a slot existed. Now we throw ERROR only if a slot is active in
the database being dropped.
Craig Ringer
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/protocol.sgml | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index ba6f8dd8d2d..78508d74ece 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -18876,7 +18876,8 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup()); <entry> Drops the physical or logical replication slot named <parameter>slot_name</parameter>. Same as replication protocol - command <literal>DROP_REPLICATION_SLOT</>. + command <literal>DROP_REPLICATION_SLOT</>. For logical slots, this must + be called when connected to the same database the slot was created on. </entry> </row> diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index b3a50261c33..5f971412ae7 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -2034,6 +2034,8 @@ The commands accepted in walsender mode are: <para> Drops a replication slot, freeing any reserved server-side resources. If the slot is currently in use by an active connection, this command fails. + If the slot is a logical slot that was created in a database other than + the database the walsender is connected to, this command fails. </para> <variablelist> <varlistentry> |