Re: Restore

Thanks Adrian but

psql –U postgres -d PDW -f PDW_June_10.sql

asks - "Password for user postgres:"

When I type the password the cursor doesn't respond and on enter I get
password failed.

Bob

-----Original Message-----
From: Adrian Klaver
Sent: Friday, December 24, 2010 2:59 PM
To: pgsql-general(at)postgresql(dot)org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore

On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote:
> Hi
>
> I am attempting to restore a database using -
>
> psql PDW < PDW_June_10.sql
>
> psql –U postgres PDW < PDW_June_10.sql

psql –U postgres -d PDW -f PDW_June_10.sql

>
> The response asks me for a password.
>
> I use the same password with which I connect to the server but it is not
> accepted.
>
> Without the –U postgres identifier it asks me for the password of my
> computer - which doesn’t exist.

Without a specified -U it psql will use your system user name.
See here for all the gory details:
http://www.postgresql.org/docs/9.0/interactive/app-psql.html

>
> How can I get around this??
>
> Bob

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com