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
-----------------
[EMAIL PROTECTED]
icq#: 34161555
http://www.rsu.ru/~sergey/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to