Hello!
I have Postgres configured so it requires password to access DB (in
pg_hba.conf).
The problem is that I want to set up an automated backup with pg_dump, but it
asks for password interactively, rather then accept password from either
command-line option or from some config-file (e.g. ~/.psqlrc)
The workaround would be to disable password requirement, but this is a
security risk I want to avoid.
Why no to add an option --password="" to command-line options of pg_dump?
--
Sincerely,
Sergey Litvinenko
-----------------
sergey(at)rsu(dot)ru
icq#: 34161555
http://www.rsu.ru/~sergey/