What is difference between START WAL LOCATION, STOP WAL LOCATION, and CHECKPOINT indicated in the backup history file?

All we need is an easy explanation of the problem, so here it is.

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

What is difference between START WAL LOCATION, STOP WAL LOCATION, and CHECKPOINT indicated in the backup history file?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

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

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply