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