pgsql: Add per-subscription wal_receiver_timeout setting.

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add per-subscription wal_receiver_timeout setting.
Date: 2026-02-19 16:02:36
Message-ID: E1vt6U8-0009qv-32@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add per-subscription wal_receiver_timeout setting.

This commit allows setting wal_receiver_timeout per subscription
using the CREATE SUBSCRIPTION and ALTER SUBSCRIPTION commands.
The value is stored in the subwalrcvtimeout column of the pg_subscription
catalog.

When set, this value overrides the global wal_receiver_timeout for
the subscription's apply worker. The default is -1, which means the
global setting (from the server configuration, command line, role,
or database) remains in effect.

This feature is useful for configuring different timeout values for
each subscription, especially when connecting to multiple publisher
servers, to improve failure detection.

Bump catalog version.

Author: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Reviewed-by: Japin Li <japinli(at)hotmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://postgr.es/m/a1414b64-bf58-43a6-8494-9704975a41e9@oss.nttdata.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/fb80f388f4a140934f51f68578ba321152332ce7

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 10 ++
doc/src/sgml/ref/alter_subscription.sgml | 5 +-
doc/src/sgml/ref/create_subscription.sgml | 15 ++-
src/backend/catalog/pg_subscription.c | 6 +
src/backend/commands/subscriptioncmds.c | 51 +++++++-
src/backend/replication/logical/worker.c | 41 +++++++
src/bin/pg_dump/pg_dump.c | 18 ++-
src/bin/pg_dump/pg_dump.h | 1 +
src/bin/psql/describe.c | 7 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_subscription.h | 4 +
src/test/regress/expected/subscription.out | 180 +++++++++++++++--------------
src/test/regress/sql/subscription.sql | 3 +
13 files changed, 245 insertions(+), 98 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2026-02-19 16:09:07 pgsql: Remove no-longer-useful markers in pg_hba.conf.sample.
Previous Message Fujii Masao 2026-02-19 14:56:02 pgsql: Log checkpoint request flags in checkpoint completion messages.