in reply to DBD::Pg on Windows with ActivePerl

Well, I clearly am a Windows Novice. As it turns out I was trying to set all of the environment variables that Postgresql and DBD::Pg docs kept mentioning to allow for linking to postgresql libraries (namely, POSTGRES_LIB, POSTGRES_INCLUDE and POSTGRES_HOME). As it turns out all DBD::Pg wanted was to have the postgresql bin dir in the PATH. The POSTGRES_ env stuff was totally irrelevant. I assume all DBD::Pg wanted was access to the pg_config.exe utility. Doesn't make sense to me that setting the other environment stuff still left it unable to find libpq.dll and such.

On another note I did try to install Strawberry perl and install DBD::Pg through CPAN. This resulted in again not being able to locate libpq.dll and such...despite putting it in the PATH, resetting all the POSTGRES environment stuff, etc. I haven't totally given up on this, but I'll save the rest of the troubleshooting for another day, as at least I have my basic DBD::Pg scripts working on a windows platform with ActivePerl.

Thanks to all for the help!

Replies are listed 'Best First'.
Re^2: DBD::Pg on Windows with ActivePerl
by Anonymous Monk on Mar 05, 2014 at 22:09 UTC
    I had the same problem. After reading the suggestions here I set PostgreSQL9.3/bin into PATH and that was it. It worked. Thanks