From: | Sbob <sbob(at)quadratum-braccas(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | could not read block 0 in file Error |
Date: | 2022-04-22 20:23:00 |
Message-ID: | 938c7425-076f-f752-de61-c5f8f183d24b@quadratum-braccas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all;
We had an issue with a PostgreSQL v12 cluster. Not sure all of the
history as I was pulled in late, however we were seeing that the db
would not start due to WAL inconsistencies, was throwing an error about
could not find wal records.
So we ran a pg_resetwal -f -D [data dir]
we are dumping (via pg_dump) all the databases in the broken cluster and
I will restore them to a new cluster,
however in one of the databases, for one of the tables we are getting this:
pg_dump: error: Dumping the contents of table "bigtable" failed:
PQgetResult() fai
led.
pg_dump: error: Error message from server: ERROR: could not read block
0 in file "base/6328739/6340053": read only 0 of 8192 bytes
pg_dump: error: The command was: COPY public.bigtable (recordid,
containerid, record_type, description, overlaygroup) TO stdout;
Is there any way to recover?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Denninger | 2022-04-22 20:29:42 | Re: could not read block 0 in file Error |
Previous Message | ravi k | 2022-04-22 16:42:49 | Re: Partitioning without downtime |