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@xxxxxxxxxxxxxx
Cc: Bob Pawley
Subject: Re: 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.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
