On Friday 24 December 2010 4:03:52 pm Bob Pawley wrote: > 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 > Lets go back to the beginning. Basic info: Pg version OS How do you normally connect to the database? Have you set up passwords for Postgres users? Remember Postgres users are not the same as system users. So when it asking for a password it is for the Postgres users password not the system users password of the same name. -- 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