If I set up Wal Archiving on a three years old Postgres database (used in production); do the Continuous Archiving and Point-in-Time Recovery (PITR) will work from the beginning? Will I have all the data? Or some logs will miss and thus, some data?

For example: So if I enabled wal archiving 3 days ago, and I want to restore to yesterday. Will I have all the data from the beginning? Or only the data from 3 days ago to yesterday?

1 Answer 1


You need to perform a base backup regularly, since you need to restore the backup before you can recover using WAL.

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.