| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgsql 9.0.1 table corruption |
| Date: | 2011-04-14 16:08:27 |
| Message-ID: | 201104140908.27547.ahodgson@simkin.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On April 14, 2011 08:10:47 am Dan Biagini wrote:
> I suspect that it may have occurred during a filesystem level backup
> (ie pg_start_backup(), tar -czf..., pg_stop_backup()), as I performed
> a backup and moved the database to a different system. After
> restoring the files and starting postgres I began getting these
> errors. I have tried restoring multiple times with the same tar
> archive with the same results (on different systems).
Did you perform a PITR restore using that tar as a base backup? Do any errors
occur? The tar file alone will not be an intact backup, as I'm sure you're
aware.
http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-
PITR-RECOVERY
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-04-14 16:25:05 | Re: Vacuumdb error |
| Previous Message | Dan Biagini | 2011-04-14 15:10:47 | pgsql 9.0.1 table corruption |