Re: Urgent !!!! Tables inaccessible postgres v17.6

Hi Ron,

Thanks for the quick response.

Unfortunately, I do have backups, but they're also reporting the same
checksum error.
full backup: 20260801-203001F
timestamp start/stop: 2026-08-01 20:30:01-07 / 2026-08-01
21:30:23-07
wal start/stop: 00000001000007F900000055 /
000000010000080800000030
database size: 1403.4GB, database backup size: 1403.4GB
repo1: backup set size: 197.7GB, backup size: 197.7GB

diff backup: 20260801-203001F_20260802-023002D
timestamp start/stop: 2026-08-02 02:30:02-07 / 2026-08-02
02:35:44-07
wal start/stop: 000000010000086A000000B6 /
000000010000086A000000B6
database size: 1407.7GB, database backup size: 221.5GB
repo1: backup set size: 198.8GB, backup size: 28.6GB
backup reference total: 1 full
error(s) detected during backup

Our backup strategy is weekly full backups with daily incremental backups.

The database is hosted on Azure Premium SSD v2, using four striped disks.

How serious does this look to you? Do you have any recommendations on the
fastest way to recover from this? At the moment, I'm concerned that both
the production copy and the backups appear to be affected.

On Thu, Aug 6, 2026 at 7:47 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:

> On Thu, Aug 6, 2026 at 10:11 AM mahamood hussain <hussain(dot)ieg(at)gmail(dot)com>
> wrote:
>
>> Hi Team,
>>
>> I need some urgent help. I'm unable to access one of the tables. Even a
>> simple SELECT statement fails with the error below. Could someone please
>> help investigate and fix this issue?
>>
>> prod=# SELECT count(*) FROM schema.tablename;
>>
>> WARNING: page verification failed, calculated checksum 50897 but expected 50048
>> ERROR: invalid page in block 696770 of relation base/16388/447758
>> CONTEXT: parallel worker
>>
>> Any assistance would be greatly appreciated. Thanks!
>>
>
> * Have you tested your backup/restore process lately?
> * How old is the latest backup?
> * Do the system logs show any errors around that time?
> * What kind of disks do you have? One might be dying.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>