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
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru