v1-0001-Improve-doc-for-idle_replication_slot_timeout.patch

text/x-patch

Filename: v1-0001-Improve-doc-for-idle_replication_slot_timeout.patch
Type: text/x-patch
Part: 0
Message: Re: Unexpected behavior when setting "idle_replication_slot_timeout"

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: format-patch
Series: patch v1-0001
Subject: Improve doc for idle_replication_slot_timeout
File+
doc/src/sgml/config.sgml 8 6
From e49ad0034ee55577c8e881b9ba4232031ba639e2 Mon Sep 17 00:00:00 2001
From: Laurenz Albe <laurenz.albe@cybertec.at>
Date: Sat, 5 Jul 2025 07:27:10 +0200
Subject: [PATCH v1] Improve doc for idle_replication_slot_timeout

Define what exactly is meant by "idle" here.  Also, emphasize that
the value is rounded to minutes, since that caused some surprise
during beta testing.

Author: Laurenz Albe <laurenz.albe@cybertec.at>
Discussion: https://postgr.es/m/CADGJaX_0%2BFTguWpNSpgVWYQP_7MhoO0D8%3Dcp4XozSQgaZ40Odw%40mail.gmail.com
---
 doc/src/sgml/config.sgml | 14 ++++++++------
 1 file changed, 8 insertions(+), 6 deletions(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 59a0874528a..2b4f9f34cf4 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -4618,12 +4618,14 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"'  # Windows
       </term>
       <listitem>
        <para>
-        Invalidate replication slots that have remained idle longer than this
-        duration. If this value is specified without units, it is taken as
-        minutes. A value of zero (the default) disables the idle timeout
-        invalidation mechanism. This parameter can only be set in the
-        <filename>postgresql.conf</filename> file or on the server command
-        line.
+        Invalidate replication slots that have been inactive (not used by a
+        <link linkend="protocol-replication">replication connection</link>)
+        for longer than this duration. If the value is specified without
+        units, it is taken as minutes. Values specified in units smaller than
+        a minute are rounded to the nearest minute. A value of zero (the
+        default) disables the idle timeout invalidation mechanism. This
+        parameter can only be set in the <filename>postgresql.conf</filename>
+        file or on the server command line.
        </para>
 
        <para>
-- 
2.50.0