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
of8192 bytes
> pg_dump: error: The command was: COPY public.bigtable (recordid, containerid, record_type, description, overlaygroup)
TOstdout;
>
> 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