Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | Allows feedback from a hot standby to the primary that will avoid query conflicts. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | hot_standby_feedback |
idle_replication_slot_timeout
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Sets the duration a replication slot can remain idle before it is invalidated. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0-35791394 |
| Parameter type | dynamic |
| Documentation | idle_replication_slot_timeout |
max_active_replication_origins
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Sets the maximum number of active replication origins. |
| Data type | integer |
| Default value | Depends on resources (vCores, RAM, or disk space) allocated to the server. |
| Allowed values | 0-262143 |
| Parameter type | static |
| Documentation | max_active_replication_origins |
max_standby_archive_delay
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Sets the maximum delay before canceling queries 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 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 |
synchronized_standby_slots
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Lists streaming replication standby server replication slot names that logical WAL sender processes will wait for. Logical WAL sender processes will send decoded changes to output plugins only after the specified replication slots have confirmed receiving WAL. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | synchronized_standby_slots |
sync_replication_slots
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Enables a physical standby to synchronize logical failover replication slots from the primary server. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | sync_replication_slots |
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 sending server. |
| 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 |
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 |
synchronized_standby_slots
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Lists streaming replication standby server replication slot names that logical WAL sender processes will wait for. Logical WAL sender processes will send decoded changes to output plugins only after the specified replication slots have confirmed receiving WAL. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | synchronized_standby_slots |
sync_replication_slots
| Attribute | Value |
|---|---|
| Category | Replication / Standby Servers |
| Description | Enables physical standby to synchronize logical failover slots from the primary server. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | sync_replication_slots |
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 |
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 |
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 | 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 |
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 | 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 |
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 | 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 |
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 | 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 |