Re: Upgrade to PGSQL 8.2 Problem

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