Regarding vacuumdb

Shanmugasundaram writes:

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.

Here 'db1' is the database and 'test1' is a table. When, displaying the
structure of the
table 'test1', it comes correctly. But I can't drop the table. What
could be wrong?

You probably rolled back a DROP TABLE operation, so the underlying table
file on disk is gone but the catalog structures have been preserved.
You could probably try

touch $PGDATA/base/db1/test1

and then drop the table.

Consider upgrading to the latest stable release (7.1.3) when you get a
chance to eliminate this class of problems.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter