0

I am a bit confused about these locations. Could someone give a short definition for these locations.

enter image description here

1

1 Answer 1

1

“Start WAL location” is the log sequence number (position in the WAL) where WAL replay starts when you recover the database.

“Stop WAL location” is the log sequence number where the backup ended. WAL has to be replayed at least to this point for the recovered data to become consistent. This is the earliest point to which you can recover (recovery_target = 'immediate').

“Checkpoint location” is the log sequence number of the WAL entry of the checkpoint that starts the base backup.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.