Hello Troy,
You could use one of these things to get it working..
Create one txt file, input the username and password in different
lines like
Username
Password
save the file(user.txt)...
Give this file as input to the pg_dump it should work
pg_dump dummy_db < user.txt > /tmp/dummy_db.sql
Hope it solves the problem, it worked for me...
Gurudutt
Tuesday, January 29, 2002, 12:38:07 AM, you wrote:
TCLc> Is there a way to supply a username and password in one command using
TCLc> pg_dump?
TCLc> For example is it possible to do this so it doesn't prompt you for a
TCLc> username/password:
TCLc> pg_dump mydb --username=dbuser --password=dbpass > myfile.out
TCLc> Thank you!
[:==>> Troy Campano <==:]
--
Best regards,
Gurudutt mailto:guru@indvalley.com
Life is not fair - get used to it.
Bill Gates