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