Re: Vacuum returns error

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

> "William Meloney" <bmeloney(at)mindspring(dot)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