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.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