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(at)club-internet(dot)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(at)club-internet(dot)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(at)postgresql(dot)org

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