From 05dedf43d380edc98546c381e76a9d907fd19bed Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Fri, 11 Jul 2025 08:39:24 +0900 Subject: Change unit of idle_replication_slot_timeout to seconds. Previously, the idle_replication_slot_timeout parameter used minutes as its unit, based on the assumption that values would typically exceed one minute in production environments. However, this caused unexpected behavior: specifying a value below 30 seconds would round down to 0, effectively disabling the timeout. This could be surprising to users. To allow finer-grained control and avoid such confusion, this commit changes the unit of idle_replication_slot_timeout to seconds. Larger values can still be specified easily using standard time suffixes, for example, '24h' for 24 hours. Back-patch to v18 where idle_replication_slot_timeout was added. Reported-by: Gunnar Morling Author: Fujii Masao Reviewed-by: Laurenz Albe Reviewed-by: David G. Johnston Reviewed-by: Amit Kapila Reviewed-by: Hayato Kuroda Reviewed-by: Tom Lane Discussion: https://postgr.es/m/CADGJaX_0+FTguWpNSpgVWYQP_7MhoO0D8=cp4XozSQgaZ40Odw@mail.gmail.com Backpatch-through: 18 --- doc/src/sgml/config.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 59a0874528a..bd12225cbe4 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4620,7 +4620,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows 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 + seconds. A value of zero (the default) disables the idle timeout invalidation mechanism. This parameter can only be set in the postgresql.conf file or on the server command line. -- cgit v1.2.3