Muokkaa

Jaa


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