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 |
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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for