>> AFAIK PITR can be used in a scenario where there is a base back-up and we >> have archived >> the WAL files after that, now it can use WAL files to apply on base-backup.
> Yes. If you want to recover the database from the media crash like the > corruption of pg_control file, you basically should take a base backup > and set up continuous archiving. >> In this scenario we don't know a point from where to start the next replay. >> So I believe it will be difficult to use PITR in this scenario. >You can find out the point from the complete pg_control file which was >restored from the backup. Yes, it can work the way you have explained or even by using Replication solutions where user can recreate the database from slave or other copy. But the tool pg_resetxlog or similar tools are provided to handle situations where user has not taken care enough to be saved from corruption. With Regards, Amit Kapila. -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers