good chemistry is complicated,
and a little bit messy -LW
PQconnectdb issue in DBI, using OSX 10.6, Perl 5.10, PostgreSQL 8.3by dwhite20899 (Pilgrim)
|on Oct 16, 2009 at 20:45 UTC||Need Help??|
dwhite20899 has asked for the
wisdom of the Perl Monks concerning the following question:
I was running Perl 5.8 on OSX 10.5 with PostgreSQL 8.3.7.
I upgraded to OSX 10.6, which brought Perl 5.10 with it.
I made sure the modules I need were installed in 5.10.
I installed DBD-Pg-2.15.1 and DBI-1.609.
When I run this code
I get this error
I searched around, tried some environment variable suggestions, reinstalled Postgres, uninstalled and reinstalled modules yet still get that PQconnectdb error.
What am I missing, here? This isn't rocket surgery.
Update: I'm going to go wander off and see what's in 32 and 64 bit territory. Will report back later...
Update (later): I uninstalled PostgreSQL, uninstalled the DBD and DBI modules; then installed PostgreSQL 8.3.7 from source again (it recognized 64-bit) and DBI and DBD::Pg, and everything works. Looking at the logs, I don't see anything different from Friday's installs, but it's happy now. (I'm not happy, but I guess I don't count.)