Re: Vacuum returns error - Mailing list pgsql-admin

From William Meloney
Subject Re: Vacuum returns error
Date
Msg-id 3CA88C04.9490.19D818FD@localhost
Whole thread Raw
In response to Vacuum returns error  ("William Meloney" <bmeloney@mindspring.com>)
List pgsql-admin
(* 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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly



pgsql-admin by date:

Previous
From: "Gill, Jeffrey L"
Date:
Subject: Re: [ic] Is Posgresql and Interchange multithreaded?
Next
From: Andre Schubert
Date:
Subject: Re: Last_Inserted Value