chris faber wrote: > Postgres 9.2 > > We have a POSTGRES database that we have been backing up via Incremental backups. You are talking of a physical base backup and WAL archives, right? > We had an incident where we had to recover from backup. Our software vendor has completed > a restore and we have lost 10 days of data. There is no explanation as to the reason we > have sustained this loss. Then press your software wendor for a reason. They did the restore, so they should know. > I would appreciate the communities help in the following: > > 1. Determine if data from the incremental backups can be restored or recovered. If properly done, you can recover to any point of time after the backup with a base backup and WAL archives. > 2. Determine if data can be recovered from individual files backed up from main Postgres > data directory. That is more tricky. There is no straightforward way to extract such information, particularly if the commit log is missing. If that file is from a base backup, there is the additional difficulty that the file could be in an inconsistent state. You would have to hire a specialist for such work. It sounds like you should consider letting somebody more reliable than your software vendor manage your database backups. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
