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 | 60000 |
Parameter type | read-only |
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 |
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 | 60000 |
Parameter type | read-only |
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 |
promote_trigger_file
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 | 60000 |
Parameter type | read-only |
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 |
promote_trigger_file
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 | 60000 |
Parameter type | read-only |
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 |
promote_trigger_file
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 | 60000 |
Parameter type | read-only |
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 |
promote_trigger_file
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 | 60000 |
Parameter type | read-only |
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 | 60000 |
Parameter type | read-only |
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 |