I have a PostgreSQL backup and WAL archived before the db snapshot was taken.
Is it possible to restore the database using PITR to a time before the snapshot was taken?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
No. You can't. PITR can let you go forward in time, not backward.
You have to have a backup taken before your WAL were created and you must have each WAL between your backup and the time you want to reach.
You can find this documentation helpfull. https://www.postgresql.org/docs/current/static/continuous-archiving.html