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 |
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.