pgsql: Allow walreceiver configuration to change on reload

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Allow walreceiver configuration to change on reload
Date: 2020-03-27 22:57:29
Message-ID: E1jHxur-00030C-Rs@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)zsrv(dot)org>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Reviewed-by: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2020-03-27 23:46:18 pgsql: Justify nbtree page split locking in code comment.
Previous Message Tom Lane 2020-03-27 20:41:39 Re: pgsql: Provide a TLS init hook