On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
> is ther a way to pass a password to the pg_dump command to avoid being
> prompted for it.
> I want to execute the dump from a perl or shell script and dont want to
> open accees for the user in the pg_hba.conf
Use the ~/.pgpass file. It will work for any libpq program, not just
pg_dump.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"I call it GNU/Linux. Except the GNU/ is silent." (Ben Reiter)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
