Thread: Regarding vacuumdb
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. 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? Any help. Thanks shan.
Bhuvaneswari <shan@ceedees.com> writes: > ERROR: mdopen: couldn't open test1: No such file or directory Looks like you tried to roll back a DROP TABLE. You can get out of the immediate problem by doing touch $PGDATA/base/db1/test1 and then drop the table. Next, run do not walk to an archive site and get a newer release of Postgres. You are at least two major releases behind the times, and I can't even begin to count the number of bugs fixed since then ... but this is one of them. regards, tom lane