"Andrew Bartley" <abartley@evolvosystems.com> writes:
> 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?
Most likely yes. Check your syslogs for kernel i/o error messages.
-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/
Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...