Re: pg_dump problem

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,

Andrew Gould

--- Mathieu Arnold <arn_mat@club-internet.fr> wrote:
>
>
> Andrew Gould wrote:
> >
> > Please show us how you executed pg_dump.  That is,
> > what syntax did you use?
> >
> > Andrew Gould
> > --- Mathieu Arnold <arn_mat@club-internet.fr>
> wrote:
> > > Hi
> > >
> > > I have a table with more than 4M entries and
> pg_dump
> > > refuses to dump it,
> > > it just sits on it waiting. As i'm backuping my
> db
> > > with pg_dump, I do
> > > have a problem here.
> > >
> > > $ postmaster -V
> > > postmaster (PostgreSQL) 7.1
> > > $ pg_dump -V
> > > pg_dump (PostgreSQL) 7.1
>
> pg_dumpall -c -N -D
>
> --
> Mathieu Arnold
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


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