Skip to content

Commit c600265

Browse files
committed
doc: Remove incorrect description about dropping replication slots.
pg_drop_replication_slot() can drop replication slots created on a different database than the one where it is executed. This behavior has been in place since PostgreSQL 9.4, when pg_drop_replication_slot() was introduced. However, commit ff539d mistakenly added the following incorrect description in the documentation: For logical slots, this must be called when connected to the same database the slot was created on. This commit removes that incorrect statement. A similar mistake was also present in the documentation for the DROP_REPLICATION_SLOT command, which has now been corrected as well. Back-patch to all supported versions. Author: Hayato Kuroda <kuroda.hayato@fujitsu.com> Reviewed-by: Fujii Masao <masao.fujii@gmail.com> Discussion: https://postgr.es/m/OSCPR01MB14966C6BE304B5BB2E58D4009F5DE2@OSCPR01MB14966.jpnprd01.prod.outlook.com Backpatch-through: 13
1 parent 474aee3 commit c600265

File tree

2 files changed

+1
-4
lines changed

2 files changed

+1
-4
lines changed

doc/src/sgml/func.sgml

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -24910,8 +24910,7 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup());
2491024910
<para>
2491124911
Drops the physical or logical replication slot
2491224912
named <parameter>slot_name</parameter>. Same as replication protocol
24913-
command <literal>DROP_REPLICATION_SLOT</literal>. For logical slots, this must
24914-
be called while connected to the same database the slot was created on.
24913+
command <literal>DROP_REPLICATION_SLOT</literal>.
2491524914
</para></entry>
2491624915
</row>
2491724916

doc/src/sgml/protocol.sgml

Lines changed: 0 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2547,8 +2547,6 @@ The commands accepted in replication mode are:
25472547
<listitem>
25482548
<para>
25492549
Drops a replication slot, freeing any reserved server-side resources.
2550-
If the slot is a logical slot that was created in a database other than
2551-
the database the walsender is connected to, this command fails.
25522550
</para>
25532551
<variablelist>
25542552
<varlistentry>

0 commit comments

Comments
 (0)