Hello. I have a perl module that uses DBI and works when executed from shell. When its run from Apache I get gibberish error on connect.
I have narrowed down that somehow my debian system had two installations of postgresql - one compiled and one via apt-get. The compiled psql in /usr/local/pgsql/bin/ worked, while psql in /usr/psql/bin gave the same sort of gibberish errors. dpkg -l claims I have postgresql and postgresql-cli installed, however when removing them with apt, it claims neither are installed. I am completely stuck and I don't know how DBI/DBD::Pg connects to postgres socket -- running the same module as the apache user works too. Pleaes help!
