On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley <rjpaw...@shaw.ca> 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.
Keep in mind, the password set for the unix account is NOT related to the password set for a user in postgresql with alter user password = 'mypassword';. If you are entering a unix password for a pg account that hasn't had the pw set, then it's not going to work. They're not related at all. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
