Re: Regarding Vacuumdb

On Tue, 28 Aug 2001, Bhuvaneswari wrote:

> hi,
> I am getting the following error while doing vacuumdb,
>
> ERROR: mdopen: couldn't open test1: No such file or directory
> vacuumdb: database vacuum failed on db1.

We got this error a lot in 6.5. Usually it means your table has somehow
been corrupted, and postgres doesn't want anything to do with it. It'll
show up, and you can even select from it, but doing so will crash the
back-end, and you can't run a vacuum or pg_dump on that database
successfully.

You'll have to do a table-by-table pg_dump, destroy the DB, and reimport
everything. You'll have to rebuild the corrupted table from scratch,
since you might not be able to dump it.

Either way, it's a lot of work. Just be careful.

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Programmer |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas(at)townnews(dot)com AIM : trifthen |
| Web : hamster.lee.net |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+