Re: Pg_dump options

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