"William Meloney" <[EMAIL PROTECTED]> writes:
> 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?
> [ info snipped ]
Okay
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 y
"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
(* 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;
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_
