Hello Dmitry,
Yes!! I fully agree with what you say, the option should've been there
in pg_dump just the way it is in mysql_dump. But Username: & Password:
won't be there in the dump file if u write the pg_dump command in a
shell script and execute it inside the shell.
Tuesday, January 29, 2002, 1:10:06 PM, you wrote:
DA> Tuesday, January 29, 2002, 7:34:17 AM, Gurudutt wrote:
>> 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...
DA> yes, it works BUT you will have lines "Username:" and "Password:" in
DA> your dump file. I think better to have these options in pg_dump (like
DA> mysql_dump has) instead of doing this work around.
--
Best regards,
Gurudutt mailto:guru@indvalley.com
Life is not fair - get used to it.
Bill Gates