Re: Vacuum returns error

On 2 Apr 2002 at 2:09, Tom Lane wrote:

> "William Meloney" <bmeloney@mindspring.com> writes:
> > 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.
>
> Hmm.  What files do you actually have in /var/lib/pgsql/pg_clog?
> (I'd like to see an ls -l of that directory if possible; the sizes
> and mod dates might be useful clues.)
total 252
-rw-------  1  postgres postgres  253952  apr  3  13:47  0000

  Another useful bit of info
> would be "select * from pg_database".
>
database  datdba  encoding  datistemplate  datallowconn  datlassysoid  datvacuumxi
qc             100            0          false                true                16554            964425
plant1       100            0          false                true                16554            964106
template1  1               0          true                 true                16554            1810
template0  1               0          true                 false               16554            49
plant2        100           0          false                true                16554            964326
plant3        100           0          false                true                16554            964264


Best of luck

- William