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

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!