Postgres Pro
Downloads
Home   >   mailing lists

Re: "could not read block" error message - Mailing list pgsql-novice

From Tom Lane
Subject Re: "could not read block" error message
Date
Msg-id 5250.1262961186@sss.pgh.pa.us
Whole thread Raw
In response to "could not read block" error message  (peter@vfemail.net)
List pgsql-novice
Tree view 
peter@vfemail.net writes:
> I have a perl script that's worked flawlessly for years to extract data from a PostgreSQL database and write the data
toa text file once a day.  The script is now terminating abnormally with this message: 

>      DBD::Pg::db selectall_arrayref failed: ERROR:
>      could not read block 53044 of relation "news":
>      Input/output error at {script name} line 93.

"Input/output error" generally means a hardware problem.  You might try
looking in the kernel log to see if there's any more info there.

            regards, tom lane

pgsql-novice by date:

Previous
From: peter@vfemail.net
Date:
Subject: "could not read block" error message
Next
From: Thomas Kellerer
Date:
Subject: Re: Help to dump tables in a database and restore in another database