Postgres Pro
Downloads
Home   >   mailing lists

cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error - Mailing list pgsql-general

From Andrew Bartley
Subject cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
Date
Msg-id 001f01c1ce0e$e408a3c0$3200a8c0@abartleypc
Whole thread Raw
Responses Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi,
 
We are using Postgres 7.1.3.
 
I run a nightly cron that drops all of the application table indexes then unload and reload the most heavily used tables to ensure they are in key sequence, then vacuum analyse the whole DB, recreate the indexes and triggers.
 
Over the weekend, this error appeared.
 
ERROR:  cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
vacuumdb: vacuum  evolvo failed
 
Could this be a physical I/O error?
 
Can someone tell me what I can do to fix this?
 
Thanks
 
Andrew Bartley.

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [ODBC] ODBC
Next
From: Doug McNaught
Date:
Subject: Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error