Vacuum returns error - Mailing list pgsql-admin

From William Meloney
Subject Vacuum returns error
Date
Msg-id 3CA86EBF.13182.1965C6B9@localhost
Whole thread Raw
Responses Re: Vacuum returns error  ("William Meloney" <bmeloney@mindspring.com>)
Re: Vacuum returns error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
PG 7.2 and RH 7.2

Developer dropped ~30+ tables from 4 different DBs on the same
server.  Queiries began to fail: unable to locate file;
/var/lib/pgsql/pg_clog/0006.

Immediately VACUUMed DBs.  Queiries began returning OK.

Minutes later vacuumdb -z DB_1, returned OK.

Attempted vacuumdb -z DB_2, failed with error similar to above.

Where can I locate more comprehensive error message
information?  Any recommendations would be greatly appreciated.

Thanks

- Bill



pgsql-admin by date:

Previous
From: "Gill, Jeffrey L"
Date:
Subject: How much memory does postgresql require?
Next
From: Peter Eisentraut
Date:
Subject: Re: Is Posgresql and Interchange multithreaded?