From: | Aarni Ruuhimäki <aarni(at)kymi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | <operationsengineer1(at)yahoo(dot)com> |
Subject: | Re: Upgrade to PGSQL 8.2 Problem |
Date: | 2006-12-14 07:05:47 |
Message-ID: | 200612140905.48015.aarni@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thursday 14 December 2006 08:52, operationsengineer1(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Hurt | 2006-12-14 19:56:51 | Getting a count from an update |
Previous Message | operationsengineer1 | 2006-12-14 06:52:24 | Re: Upgrade to PGSQL 8.2 Problem |