(* NOTE: I realize that answering your own posts is like talking to yourself, please forgive me... *)
On 1 Apr 2002 at 14:29, William Meloney wrote: > 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. pg_dump DB_2 failed citing a specific table as the point of failure. A review of the dump file ( DB_2.txt.gz) gave the last record number of the table BEFORE it failed. We then executed a DELETE query and removed the offending record in the cited table. An immediate pg_dump completed successfully. Confidence is high that a vacuum will complete as well. > > Where can I locate more comprehensive error message > information? Any recommendations would be greatly appreciated. > > Thanks > > - Bill > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
