On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote: > Hi > > I am attempting to restore a database using - > > psql PDW < PDW_June_10.sql > > psql âU postgres PDW < PDW_June_10.sql psql âU postgres -d PDW -f PDW_June_10.sql > > The response asks me for a password. > > I use the same password with which I connect to the server but it is not > accepted. > > Without the âU postgres identifier it asks me for the password of my > computer - which doesnât exist. Without a specified -U it psql will use your system user name. See here for all the gory details: http://www.postgresql.org/docs/9.0/interactive/app-psql.html > > How can I get around this?? > > Bob -- 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