| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Sbob <sbob(at)quadratum-braccas(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: could not read block 0 in file Error |
| Date: | 2022-04-22 21:22:35 |
| Message-ID: | fb7da4bd1fe790ffee49a3ffd0f004ff421276ed.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 2022-04-22 at 14:23 -0600, Sbob wrote:
> pg_dump: error: Dumping the contents of table "bigtable" failed: PQgetResult() failed.
> 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?
No. The file is obviously empty, so the data in that table are lost.
Your only hope is a good backup.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2022-04-25 00:15:28 | Re: Estimating HugePages Requirements? |
| Previous Message | Karl Denninger | 2022-04-22 20:29:42 | Re: could not read block 0 in file Error |