corrupt data from invalid recovery - Mailing list pgsql-general

From CS_DBA
Subject corrupt data from invalid recovery
Date
Msg-id 53D9ABF2.2090707@consistentstate.com
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: Chris Curvey
Date:
Subject: Re: Inconsistent results postgresql
Next
From: Tonny
Date:
Subject: BDR Postgres