Write-Ahead Log / Recovery Target

recovery_target

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Set to "immediate" to end recovery as soon as a consistent state is reached.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target

recovery_target_action

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the action to perform upon reaching the recovery target.
Data type enumeration
Default value pause
Allowed values pause
Parameter type read-only
Documentation recovery_target_action

recovery_target_inclusive

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets whether to include or exclude transaction with recovery target.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation recovery_target_inclusive

recovery_target_lsn

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the LSN of the write-ahead log location up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_lsn

recovery_target_name

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the named restore point up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_name

recovery_target_time

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the time stamp up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_time

recovery_target_timeline

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Specifies the timeline to recover into.
Data type string
Default value latest
Allowed values latest
Parameter type read-only
Documentation recovery_target_timeline

recovery_target_xid

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the transaction ID up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_xid

recovery_target

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Set to "immediate" to end recovery as soon as a consistent state is reached.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target

recovery_target_action

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the action to perform upon reaching the recovery target.
Data type enumeration
Default value pause
Allowed values pause
Parameter type read-only
Documentation recovery_target_action

recovery_target_inclusive

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets whether to include or exclude transaction with recovery target.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation recovery_target_inclusive

recovery_target_lsn

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the LSN of the write-ahead log location up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_lsn

recovery_target_name

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the named restore point up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_name

recovery_target_time

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the time stamp up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_time

recovery_target_timeline

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Specifies the timeline to recover into.
Data type string
Default value latest
Allowed values latest
Parameter type read-only
Documentation recovery_target_timeline

recovery_target_xid

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the transaction ID up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_xid

recovery_target

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Set to "immediate" to end recovery as soon as a consistent state is reached.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target

recovery_target_action

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the action to perform upon reaching the recovery target.
Data type enumeration
Default value pause
Allowed values pause
Parameter type read-only
Documentation recovery_target_action

recovery_target_inclusive

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets whether to include or exclude transaction with recovery target.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation recovery_target_inclusive

recovery_target_lsn

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the LSN of the write-ahead log location up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_lsn

recovery_target_name

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the named restore point up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_name

recovery_target_time

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the time stamp up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_time

recovery_target_timeline

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Specifies the timeline to recover into.
Data type string
Default value latest
Allowed values latest
Parameter type read-only
Documentation recovery_target_timeline

recovery_target_xid

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the transaction ID up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_xid

recovery_target

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Set to "immediate" to end recovery as soon as a consistent state is reached.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target

recovery_target_action

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the action to perform upon reaching the recovery target.
Data type enumeration
Default value pause
Allowed values pause
Parameter type read-only
Documentation recovery_target_action

recovery_target_inclusive

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets whether to include or exclude transaction with recovery target.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation recovery_target_inclusive

recovery_target_lsn

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the LSN of the write-ahead log location up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_lsn

recovery_target_name

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the named restore point up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_name

recovery_target_time

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the time stamp up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_time

recovery_target_timeline

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Specifies the timeline to recover into.
Data type string
Default value latest
Allowed values latest
Parameter type read-only
Documentation recovery_target_timeline

recovery_target_xid

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the transaction ID up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_xid

recovery_target

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Set to "immediate" to end recovery as soon as a consistent state is reached.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target

recovery_target_action

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the action to perform upon reaching the recovery target.
Data type enumeration
Default value pause
Allowed values pause
Parameter type read-only
Documentation recovery_target_action

recovery_target_inclusive

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets whether to include or exclude transaction with recovery target.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation recovery_target_inclusive

recovery_target_lsn

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the LSN of the write-ahead log location up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_lsn

recovery_target_name

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the named restore point up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_name

recovery_target_time

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the time stamp up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_time

recovery_target_timeline

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Specifies the timeline to recover into.
Data type string
Default value latest
Allowed values latest
Parameter type read-only
Documentation recovery_target_timeline

recovery_target_xid

Attribute Value
Category Write-Ahead Log / Recovery Target
Description Sets the transaction ID up to which recovery will proceed.
Data type string
Default value
Allowed values
Parameter type read-only
Documentation recovery_target_xid

Note

Azure Database for PostgreSQL Flexible Server 11 does not have any server parameter in the 'Write-Ahead Log / Recovery Target' category.