↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

recovery_target_lsn

This parameter specifies the LSN of the write-ahead log location up to which recovery will proceed. The precise stopping point is also influenced by recovery_target_inclusive. This parameter is parsed using the system data type pg_lsn.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
Unknown
category
Write-Ahead Log / Recovery Target
context
postmaster
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
recovery_target_lsn
short desc
Sets the LSN of the write-ahead log location up to which recovery will proceed.
source
pg-settings-source-snapshot
unit
Unknown
vartype
string

Definition PG 18

This parameter specifies the LSN of the write-ahead log location up to which recovery will proceed. The precise stopping point is also influenced by recovery_target_inclusive. This parameter is parsed using the system data type pg_lsn.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:a3cb3f7b9fd0430300b700e36138a6559230c8eb799cdff8d56f02bc18715a05

Text language: en · wiki-repair-20261023:a3cb3f7b9fd0430300b700e36138a6559230c8eb799cdff8d56f02bc18715a05