Re: splitting a table?

--i know! i'm having problems doing pg_dumps now
--... i'm getting 'corrupt memory' errors more and
--more when i dump the tables ... and the ones
--where it can't find the index and aborts the
--dump.

--that and the fact that i don't have much
--disk space to work with ... (i know ... no
--excuse!)

--guilty.

-X

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, June 20, 2003 11:05 AM
To: Johnson, Shaunn
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] splitting a table?

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> --haven't done a vaccumdb / analyze
> --on the entire db lately because of
> --the errors i get

> FATAL 2: open of /var/lib/pgsql/data/pg_clog/0003 failed: No such file or
> directory

You need to be dealing with that, not ignoring it. An update to 7.2.4
might help.

regards, tom lane