Skip site navigation (1) Skip section navigation (2)

Re: Upgrade to PGSQL 8.2 Problem

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: operationsengineer1(at)yahoo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgrade to PGSQL 8.2 Problem
Date: 2006-12-14 03:00:58
Message-ID: 4580BE6A.1080602@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-novice
operationsengineer1(at)yahoo(dot)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

In response to

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2006-12-14 06:52:24
Subject: Re: Upgrade to PGSQL 8.2 Problem
Previous:From: Richard Broersma JrDate: 2006-12-14 02:58:49
Subject: Re: Upgrade to PGSQL 8.2 Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group