Re: could not read block 0 in file Error - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: could not read block 0 in file Error
Date
Msg-id fb7da4bd1fe790ffee49a3ffd0f004ff421276ed.camel@cybertec.at
Whole thread Raw
In response to could not read block 0 in file Error  (Sbob <sbob@quadratum-braccas.com>)
List 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
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




pgsql-admin by date:

Previous
From: Karl Denninger
Date:
Subject: Re: could not read block 0 in file Error
Next
From: Wells Oliver
Date:
Subject: CTEs and temp_buffers?