May 2018
Intermediate to advanced
576 pages
30h 25m
English
If you have a backup made with pg_dump utility, then give up all hope of using that as a starting point for a PITR. It's a frequently asked question, but the answer is still no. The reason it gets asked is exactly why we are pleading with you to plan your backups ahead of time.
First, you need to decide from what point in time you would like to recover. If the answer is as late as possible, then you don't need to do a PITR at all, just recover until the end of the logs.