Re: Upgrade to PGSQL 8.2 Problem

--- Sean Davis <sdavis2@mail.nih.gov> wrote:

> operationsengineer1@yahoo.com wrote:
> > hi all,
> >
> > i'm trying to upgrade my windows dev box to pgsql
> 8.2.
> >  i currently have 8.1 istalled.
> >
> > i've read through the docs and here is what i want
> to
> > do:
> >
> > 1. install 8.2.0-1 alongside 8.1.
> > 2. pg_dumpall > db.out # using 8.2's psql.
> > 3. path to psql.exe> psql -d postgres -f db.out #
> > using 8.2's psql.
> >
> > before i get started, though, i want to pg_dumpall
> > from my current installation (8.1).
> >
> > 1. start  windows' cli
> > 2. navigate to psql.exe directory
> > 3. psql [db name]
> > 4. [db name]-# pg_dumpall db.out
> >
> > after i hit enter, it returns the psql command
> line:
> >
> > [db name]-#
> >
> > when i search my file system for db.out, though,
> it
> > doesn't exist.
> >
> > what am i doing wrong?  i have been doing this via
> > pgadmin in the past (maybe once or twice in a
> couple
> > years), but i want to get more familiar with the
> the
> > cli and psql.
> >
> 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



____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited