Thread: corrupt data from invalid recovery

corrupt data from invalid recovery

From
CS_DBA
Date:
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