corrupt data from invalid recovery

Started by CS DBAover 11 years ago1 messagesgeneral
Jump to latest
#1CS DBA
cs_dba@consistentstate.com

We are trying to help a client, one of their databases was being backed
up via snapshots without running a pg_start_backup or pg_stop _backup
Recently they had an issue and they recovered from one of these snapshot
backups, which are now producing errors such as :

Invalid page header in block XX of relation �tablename�

they have attempted to run reindexes and vacuum full's, even backing up
the restored database but all ultimately ending in relation/page
issues... Any suggestions on how we might fix this for them?

Thanks in advance

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general