diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-01-14 14:07:11 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-01-14 14:40:41 +0100 |
| commit | 329730827848f61eb8d353d5addcbd885fa823da (patch) | |
| tree | bc56c793767f2d367e668a530888822f264713b4 /doc/src | |
| parent | ee4ac46c8eb289bc200d0fd682e75d11b4c55b5a (diff) | |
| download | postgresql-329730827848f61eb8d353d5addcbd885fa823da.tar.gz postgresql-329730827848f61eb8d353d5addcbd885fa823da.zip | |
walreceiver uses a temporary replication slot by default
If no permanent replication slot is configured using
primary_slot_name, the walreceiver now creates and uses a temporary
replication slot. A new setting wal_receiver_create_temp_slot can be
used to disable this behavior, for example, if the remote instance is
out of replication slots.
Reviewed-by: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Discussion: https://www.postgresql.org/message-id/CA%2Bfd4k4dM0iEPLxyVyme2RAFsn8SUgrNtBJOu81YqTY4V%2BnqZA%40mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 5d1c90282f9..5d45b6f7cba 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4124,6 +4124,26 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </listitem> </varlistentry> + <varlistentry id="guc-wal-receiver-create-temp-slot" xreflabel="wal_receiver_create_temp_slot"> + <term><varname>wal_receiver_create_temp_slot</varname> (<type>boolean</type>) + <indexterm> + <primary><varname>wal_receiver_create_temp_slot</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies whether a WAL receiver should create a temporary replication + slot on the remote instance when no permanent replication slot to use + has been configured (using <xref linkend="guc-primary-slot-name"/>). + 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 <filename>postgresql.conf</filename> + file or on the server command line. Changes only take effect when the + WAL receiver process starts a new connection. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-wal-receiver-status-interval" xreflabel="wal_receiver_status_interval"> <term><varname>wal_receiver_status_interval</varname> (<type>integer</type>) <indexterm> |