On 2 Apr 2002 at 2:09, Tom Lane wrote:
> "William Meloney" <[EMAIL PROTECTED]> 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
---------------------------(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
