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? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
