From 092c6936de49effe63daad94855bcd8ef26a09dd Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 27 Mar 2020 16:04:52 -0300 Subject: Set wal_receiver_create_temp_slot PGC_POSTMASTER MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Commit 329730827848 gave walreceiver the ability to create and use a temporary replication slot, and made it controllable by a GUC (enabled by default) that can be changed with SIGHUP. That's useful but has two problems: one, it's possible to cause the origin server to fill its disk if the slot doesn't advance in time; and also there's a disconnect between state passed down via the startup process and GUCs that walreceiver reads directly. We handle the first problem by setting the option to disabled by default. If the user enables it, its on their head to make sure that disk doesn't fill up. We handle the second problem by passing the flag via startup rather than having walreceiver acquire it directly, and making it PGC_POSTMASTER (which ensures a walreceiver always has the fresh value). A future commit can relax this (to PGC_SIGHUP again) by having the startup process signal walreceiver to shutdown whenever the value changes. Author: Sergei Kornilov Reviewed-by: Michael Paquier Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/20200122055510.GH174860@paquier.xyz --- doc/src/sgml/config.sgml | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 355b408b0a6..b5de6c32376 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4163,11 +4163,7 @@ ANY num_sync ( ). - The default is on. The only reason to turn this off would be if the - remote instance is currently out of available replication slots. This - parameter can only be set in the postgresql.conf - file or on the server command line. Changes only take effect when the - WAL receiver process starts a new connection. + The default is off. This parameter can only be set at server start. -- cgit v1.2.3