询问 Learn
询问 Learn
Focus mode
Replication / Standby Servers
本文内容
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
primary_conninfo
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the connection string to be used to connect to the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_conninfo
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the name of the replication slot to use on the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_slot_name
recovery_min_apply_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the minimum delay for applying changes during recovery.
Data type
integer
Default value
0
Allowed values
0
Parameter type
read-only
Documentation
recovery_min_apply_delay
wal_receiver_create_temp_slot
Attribute
Value
Category
Replication / Standby Servers
Description
Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
Data type
boolean
Default value
off
Allowed values
off
Parameter type
read-only
Documentation
wal_receiver_create_temp_slot
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the sending server.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
primary_conninfo
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the connection string to be used to connect to the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_conninfo
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the name of the replication slot to use on the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Specifies a file name whose presence ends recovery in the standby.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
recovery_min_apply_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the minimum delay for applying changes during recovery.
Data type
integer
Default value
0
Allowed values
0
Parameter type
read-only
Documentation
recovery_min_apply_delay
wal_receiver_create_temp_slot
Attribute
Value
Category
Replication / Standby Servers
Description
Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
Data type
boolean
Default value
off
Allowed values
off
Parameter type
read-only
Documentation
wal_receiver_create_temp_slot
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the sending server.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
primary_conninfo
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the connection string to be used to connect to the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_conninfo
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the name of the replication slot to use on the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Specifies a file name whose presence ends recovery in the standby.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
recovery_min_apply_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the minimum delay for applying changes during recovery.
Data type
integer
Default value
0
Allowed values
0
Parameter type
read-only
Documentation
recovery_min_apply_delay
wal_receiver_create_temp_slot
Attribute
Value
Category
Replication / Standby Servers
Description
Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
Data type
boolean
Default value
off
Allowed values
off
Parameter type
read-only
Documentation
wal_receiver_create_temp_slot
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the sending server.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
primary_conninfo
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the connection string to be used to connect to the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_conninfo
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the name of the replication slot to use on the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Specifies a file name whose presence ends recovery in the standby.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
recovery_min_apply_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the minimum delay for applying changes during recovery.
Data type
integer
Default value
0
Allowed values
0
Parameter type
read-only
Documentation
recovery_min_apply_delay
wal_receiver_create_temp_slot
Attribute
Value
Category
Replication / Standby Servers
Description
Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
Data type
boolean
Default value
off
Allowed values
off
Parameter type
read-only
Documentation
wal_receiver_create_temp_slot
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the sending server.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
primary_conninfo
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the connection string to be used to connect to the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_conninfo
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the name of the replication slot to use on the sending server.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
primary_slot_name
Attribute
Value
Category
Replication / Standby Servers
Description
Specifies a file name whose presence ends recovery in the standby.
Data type
string
Default value
Allowed values
Parameter type
read-only
Documentation
recovery_min_apply_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the minimum delay for applying changes during recovery.
Data type
integer
Default value
0
Allowed values
0
Parameter type
read-only
Documentation
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the sending server.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval
hot_standby
Attribute
Value
Category
Replication / Standby Servers
Description
Allows connections and queries during recovery.
Data type
boolean
Default value
on
Allowed values
on
Parameter type
read-only
Documentation
hot_standby
hot_standby_feedback
Attribute
Value
Category
Replication / Standby Servers
Description
Enables/disables the option whether hot standby needs to send feedback to the primary or upstream standby about queries currently executing on the standby.
Data type
boolean
Default value
off
Allowed values
on,off
Parameter type
dynamic
Documentation
hot_standby_feedback
max_standby_archive_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing archived WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_archive_delay
max_standby_streaming_delay
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum delay before canceling queries that conflict when a hot standby server is processing streamed WAL data.
Data type
integer
Default value
30000
Allowed values
-1-2147483647
Parameter type
dynamic
Documentation
max_standby_streaming_delay
wal_receiver_status_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum interval between WAL receiver status reports to the primary.
Data type
integer
Default value
10
Allowed values
0-2147483
Parameter type
dynamic
Documentation
wal_receiver_status_interval
wal_receiver_timeout
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the maximum wait time to receive data from the primary.
Data type
integer
Default value
60000
Allowed values
0-2147483647
Parameter type
dynamic
Documentation
wal_receiver_timeout
wal_retrieve_retry_interval
Attribute
Value
Category
Replication / Standby Servers
Description
Sets the time to wait before retrying to retrieve WAL after a failed attempt.
Data type
integer
Default value
5000
Allowed values
5000
Parameter type
read-only
Documentation
wal_retrieve_retry_interval