pg_dump and password required - Mailing list pgsql-bugs

From Sergey Litvinenko
Subject pg_dump and password required
Date
Msg-id 200710150105.05800.sergey@rsu.ru
Whole thread Raw
Responses Re: pg_dump and password required
List pgsql-bugs
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@rsu.ru
icq#: 34161555
http://www.rsu.ru/~sergey/

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3675: Crash on xpath function with 2 parameters
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: pg_dump and password required