Feature request - pg_dump - -W specify pwd in command line

Started by Carl Hollidayover 15 years ago2 messagesbugs
Jump to latest
#1Carl Holliday
skysnake@wonderland.co.za

Afternoon

the 8.4 pg_dump seems to work fine and as documented.

I need to be able to put pwds in the command line to facilitate
non-supervised backups etc

I tried the following command line but, understandably, it refuses to
cooperate:

pg_dump.exe -h localhost -p 5432 -U postgres -W tstpwd1 -t TRAN -t CLIENT -t
?CAS -F custom -b -Z 9 -f "C:\data\fidTcarl.sqlnative" fid2

-W tstpwd1

-W forces a password prompt, if I insert my 'test password' into the
commandline instruction, it just terminates with a

pg_dump: too many command-line arguments (first is "-t") blah

is there another way to insert the pwd into the command line interface,
please?

Carl

Carl Holliday
t 012 342 3096
skysnake@wonderland.co.za

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Carl Holliday (#1)
Re: Feature request - pg_dump - -W specify pwd in command line

"Carl Holliday" <skysnake@wonderland.co.za> writes:

I need to be able to put pwds in the command line to facilitate
non-supervised backups etc

We intentionally do not allow passwords on the command line, because
putting them there is a huge security hole. Use a ~/.pgpass file
instead. See
http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html

regards, tom lane