Alternatively you can login with your password as normal and then once in psql use the '\i filename' command to read in your backup.
E.g., psql dbname Password: dbname=# \i database.bak dbname=# \q Regards - Paul Breen --- Jeff Frost <[EMAIL PROTECTED]> wrote: > Use the .pgpass file. > > On Thu, 1 Dec 2005, Theo Galanakis wrote: > > > database.bak prompts me for a password. How can I > run the psql command > > without being prompted for a password. The > password prompt and < command > > -- > Jeff Frost, Owner <[EMAIL PROTECTED]> > Frost Consulting, LLC > http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
