On Thursday 14 December 2006 08:52, operationsengineer1@yahoo.com wrote:
> > pg_dumpall is a command-line program, just like
> > psql. It is not run
> > from within psql. It looks like that is your
> > confusion.
> >
> > Sean
>
> Sean, i agree. that is my confusion. alright. i'll
> try it tomorrow. i'll follow Richard's advice and do
> the user and password options. hopefully, all goes
> well.
>
> thanks for clarifying this.
>
> oe1
So instead of
> > 3. psql [db name]
> > 4. [db name]-# pg_dumpall db.out
you should do something like this (on linux):
/path/to/pg_bin/pg_dumpall > /path/to/dump/dir/db.out
or maybe
/path/to/pg_bin/pg_dumpall -c > /path/to/dump/dir/db.out
and then
/path/to/pg_bin/psql [-E template1 | ENCODING] < ../db.out
BR,
--
Aarni Ruuhimäki