vacuum error

From: brian <webmaster(at)misanthropia(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: vacuum error
Date: 2001-06-14 14:38:26
Message-ID: 3B28CC62.6970E9AD@misanthropia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Friends,

Help...

I have a small database with a few tables and a view. When I issue the
vacuum command, I get:

ERROR: cannot read block 5 of pg_description_objoid_index: Input/output
error

Same thing happens when I try pg_dump or pg_dumpall as well. With
pg_dump, I can dump individual tables successfully, but I still get the
error.

Oh yeah, I can vacuum individual tables, no problem.

What can I do?

Thanks,

Brian
--
proud to be microsoft free
--

Browse pgsql-admin by date

  From Date Subject
Next Message DHSC Webmaster 2001-06-14 14:49:44 Re: performance issues
Previous Message Sébastien HEITZMANN 2001-06-14 07:52:58 Re: Transactions and Locks writing in PLPGSQL