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/