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 <jeff@xxxxxxxxxxxxxxxxxxxxxx> 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 <jeff@xxxxxxxxxxxxxxxxxxxxxx> > 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 >
