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