pgsql: Allow walreceiver configuration to change on reload - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Allow walreceiver configuration to change on reload
Date
Msg-id E1jHxur-00030C-Rs@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Allow walreceiver configuration to change on reload

The parameters primary_conninfo, primary_slot_name and
wal_receiver_create_temp_slot can now be changed with a simple "reload"
signal, no longer requiring a server restart.  This is achieved by
signalling the walreceiver process to terminate and having it start
again with the new values.

Thanks to Andres Freund, Kyotaro Horiguchi, Fujii Masao for discussion.

Author: Sergei Kornilov <sk@zsrv.org>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/19513901543181143@sas1-19a94364928d.qloud-c.yandex.net

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1e6148032e4d27aec75c49264b47ad193405a919

Modified Files
--------------
doc/src/sgml/config.sgml                      |  23 ++++-
doc/src/sgml/high-availability.sgml           |   4 +-
src/backend/access/transam/xlog.c             | 136 +++++++++++++++++---------
src/backend/access/transam/xlogreader.c       |   6 +-
src/backend/postmaster/startup.c              |  38 ++++++-
src/backend/replication/walreceiver.c         |   6 +-
src/backend/utils/misc/guc.c                  |   6 +-
src/backend/utils/misc/postgresql.conf.sample |   3 -
src/include/access/xlog.h                     |   1 +
src/test/recovery/t/001_stream_rep.pl         |  24 ++++-
10 files changed, 179 insertions(+), 68 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Set wal_receiver_create_temp_slot PGC_POSTMASTER
Next
From: Peter Geoghegan
Date:
Subject: pgsql: Justify nbtree page split locking in code comment.