You could use one of these things to get it working..
Create one txt file, input the username and password in different
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...
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> For example is it possible to do this so it doesn't prompt you for a
TCLc> pg_dump mydb --username=dbuser --password=dbpass > myfile.out
TCLc> Thank you!
[:==>> Troy Campano <==:]
Life is not fair - get used to it.
In response to
pgsql-general by date
|Next:||From: Lamar Owen||Date: 2002-01-29 05:36:06|
|Subject: Re: 7.2 RPMs (Re: [HACKERS] PostgreSQL v7.2rc2 Released)|
|Previous:||From: Jason Watkins||Date: 2002-01-29 05:28:56|
|Subject: Re: Moving my business to PostgreSQL|