DBD::Pg and .pgpass - Mailing list pgsql-interfaces

From Brian Trammell
Subject DBD::Pg and .pgpass
Date
Msg-id e17e509c3f4ead15ab1dffe9d157aadc@cert.org
Whole thread Raw
Responses Re: DBD::Pg and .pgpass
List pgsql-interfaces
Greetings,

I'm trying to run a Perl script connecting to a PostgreSQL database via 
DBI and DBD::Pg as a cron job. I'm already using the .pgpass mechanism 
for managing md5 passwords on the client side and would like to use the 
same mechanism for connecting from the Perl script. This does not, 
however, appear to work. Passing either "" or undef for the password 
yields "no password supplied at <script> line <line>".

Though I could (and probably will, as I'm under some time pressure 
here) easily hack in a .pgpass parser to the Perl script, this strikes 
me as unconscionably inelegant. Is there some magic I'm missing to get 
DBD::Pg to play nice with .pgpass, or is this a bug in DBD::Pg (1.21) 
or the Postgres (8.0.1) client side itself?

Regards,

Brian

--
Brian H. Trammell / MTS, CERT/NetSA / <bht@cert.org> / 412.268.9748



pgsql-interfaces by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: questions about transaction and rollback
Next
From: Noureddine tezniti
Date:
Subject: Error in PG installation