From: | Brian Trammell <bht(at)cert(dot)org> |
---|---|
To: | psql-interfaces(at)postgresql(dot)org |
Subject: | DBD::Pg and .pgpass |
Date: | 2005-04-13 19:04:57 |
Message-ID: | e17e509c3f4ead15ab1dffe9d157aadc@cert.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers 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(at)cert(dot)org> / 412.268.9748
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-04-13 19:43:03 | Re: System vs non-system casts |
Previous Message | Josh Berkus | 2005-04-13 18:35:36 | Re: PLM pulling from CVS nightly for testing in STP |
From | Date | Subject | |
---|---|---|---|
Next Message | Noureddine tezniti | 2005-04-14 11:58:42 | Error in PG installation |
Previous Message | Greg Sabino Mullane | 2005-04-13 02:00:34 | Re: How to retrieve how many rows are affected after doing an INSERT statement |