From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Add pg_promote function |
Date: | 2018-10-25 00:46:43 |
Message-ID: | E1gFTnP-0006nb-ES@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Add pg_promote function
This function is able to promote a standby with this new SQL-callable
function. Execution access can be granted to non-superusers so that
failover tools can observe the principle of least privilege.
Catalog version is bumped.
Author: Laurenz Albe
Reviewed-by: Michael Paquier, Masahiko Sawada
Discussion: https://postgr.es/m/6e7c79b3ec916cf49742fb8849ed17cd87aed620.camel@cybertec.at
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/10074651e3355e2405015f6253602be8344bc829
Modified Files
--------------
doc/src/sgml/func.sgml | 19 ++++++++
doc/src/sgml/high-availability.sgml | 19 ++++----
doc/src/sgml/monitoring.sgml | 6 ++-
doc/src/sgml/recovery-config.sgml | 3 +-
src/backend/access/transam/xlog.c | 6 ---
src/backend/access/transam/xlogfuncs.c | 77 ++++++++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 6 +++
src/backend/postmaster/pgstat.c | 3 ++
src/include/access/xlog.h | 6 +++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 4 ++
src/include/pgstat.h | 1 +
src/test/recovery/t/004_timeline_switch.pl | 11 +++--
13 files changed, 143 insertions(+), 20 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-10-26 00:30:52 | pgsql: Add tab completion of EXECUTE FUNCTION for CREATE TRIGGER in psq |
Previous Message | Peter Eisentraut | 2018-10-25 00:03:44 | pgsql: Apply unconstify() in more places |