I have tried this a number of times -
psql âU postgres PDW < PDW_June_10.sql. (with and without spaces between U &
postgres and/or < and PDW_June)
Sometimes I am asked for a postgres password, once I was asked for the PDW
password (this makes sense and which I did enter).
When I entered the password it either said password failed or it simply went
back to the root command.
No database information was sent.
pg_hba.conf sets method as md5
I don't know what is meant by your reference to \1.
Bob
-----Original Message-----
From: bricklen
Sent: Friday, December 24, 2010 3:47 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Restore
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx>
wrote:
On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote:
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
A little bit of testing on my part showed that your form of connecting
should
work also i.e.psql âU postgres PDW < PDW_June_10.sql.
A couple of questions.
Can you connect to a database using psql and -U postgres?
Does the postgres user have a password?
If you can connect to a database with psql what does \l show? What I am
looking
for is whether PDW has its case preserved or not?
How about the pg_hba.conf setting? Is it set to something like md5?
--
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
