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
