Re: pg_dump problem

What's the status of the server? Is the file size
still increasing?

Did you vacuum the databases prior to dumping?

Andrew

--- Mathieu Arnold <arn_mat(at)club-internet(dot)fr> wrote:
>
>
> Andrew Gould wrote:
> >
> > Give the command a place to put the data dump.
> For
> > Example:
> >
> > pg_dumpall -c -N -D > backup
> >
> > or, if you need it compressed (and assuming you're
> > running Unix or Linux), pipe it through gzip:
> >
> > pg_dumpall -c -N -D | gzip -c > backup.gz
> >
> > Best of luck,
>
> well, it's already doing this :
> /opt/pg/bin/pg_dumpall -c -N -D |gzip -c9 >
> $SAVE$DATE-blemish-pgsql.tgz
> but the fact is that when it arrives on the big
> table, it just sits
> there doing nothing (and i mean nothing). It was
> still working with
> about 3M rows.
>
> --
> Mathieu Arnold

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/