postgres.git / summary / log / commit / refs

commit    14413d0ef5df4df4cad36cfe657e3f9d1f94bc2f
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Fri Mar 21 03:56:39 2025 +0000
First released in: 18.0, 13.21, 14.18, 15.13, 16.9, 17.5

    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


 doc/src/sgml/func.sgml     | 3 +--
 doc/src/sgml/protocol.sgml | 2 --
 2 files changed, 1 insertion(+), 4 deletions(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 2ab5661602c..6fa1d6586b8 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -29452,8 +29452,7 @@ postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset
        <para>
         Drops the physical or logical replication slot
         named <parameter>slot_name</parameter>. Same as replication protocol
-        command <literal>DROP_REPLICATION_SLOT</literal>. For logical slots, this must
-        be called while connected to the same database the slot was created on.
+        command <literal>DROP_REPLICATION_SLOT</literal>.
        </para></entry>
       </row>
 
diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml
index 3bd9e68e6ce..04d8e7d21af 100644
--- a/doc/src/sgml/protocol.sgml
+++ b/doc/src/sgml/protocol.sgml
@@ -2802,8 +2802,6 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
      <listitem>
       <para>
        Drops a replication slot, freeing any reserved server-side resources.
-       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>


[parent: 00b52c3db66c]