Subject: Re: No library found for -lpq
Newsgroups: gmane.comp.db.postgresql.dbdpg
Date: 2006-07-12 19:55:59 GMT (2 years, 51 weeks, 1 day, 12 hours and 1 minute ago)
I wanted to take care of all this a few weeks ago but haven't had the chance, sorry for the delay. 5.6: ppm install http://dbdpgppm.projects.postgresql.org/DBD-Pg-5.6.ppd 5.8 ppm install http://dbdpgppm.projects.postgresql.org/DBD-Pg-5.8.ppd Also, after some research I think the biggest problem with the people who get the can't load module error is because they are lacking msvcr71.dll on their system. As I understand it msvcr71.dll is a fully redistributable dll, would we be allowed to post it on pgfoundry along with the other files? If not I will at least mention on the project site that it's needed. Another (smaller) problem are the dependencies on ssleay32.dll and libeay32.dll. I was thinking about creating a separate ppm that includes the openssl dlls (and places them in the same dir with Pg.dll). In which case perhaps I should also create a ppm that includes msvcr71.dll, as well. I mean, this is for windows; installation is supposed to be brainless, right? :) Any thoughts? Andrew Dunstan wrote: > wolfgang.wening@... wrote: > >> Dear DBD-Pg experts! >> >> I tried to install DBD::Pg 1.49 on WINDOWS XP following the README.win32 >> file, but I still have serious problems. >> >> Because I found no possibility to compile postgresql from the source files >> (MS VC++ Toolkit 2003 is no longer available and Microsoft Visaul C++ 2005 >> Express Edition gives errors), I installed directly the windows version of >> PostgreSQL. ActivePerl 5.8.8.817 is already installed, also nmake and DBI >> 1.50. >> >> So instead of the described steps I did the following: >> - Step 3 >> I copied pg_config.exe directly from my installed PostgreSQL to the >> installation directory ...\DBD-Pg-1.49 >> - Step 4 >> Because in my installation of PostgreSQL I didn't find libpq.dll, I >> downloaded postgresql-8.1.4-1-binaries-no-installer.zip, unzipped it to a >> temporary directory ...\postgresql-8.1.4-1-binaries-no-installer (...\ is >> some temporary path). >> - Step 7 >> I set the variables as follws: >> POSTGRES_INCLUDE=...\postgresql-8.1.4-1-binaries-no-installer\include >> POSTGRES_LIB=...\postgresql-8.1.4-1-binaries-no-installer\lib >> - Step 8 >> I changed to ...\DBD-Pg-1.49 and called perl Makefile.PL resulting in the >> error message: "Note (probably harmless): No library found for -lpq" >> Ignoring this I tried to call nmake, but this ended in a fatal error, >> because the linker could not resolve some extern symbols. >> >> Surfing through the net I found answers to that problem like "there is >> missing the library libpq, that is part of the postgres installation". >> Sarching for files like that I found libpq-fe.h, libpq.a, and libpq.dll in >> my paths POSTGRES_INCLUDE and POSTGRES_LIB respectively. >> >> Can you tell me what's going wrong? Are there missing files or environment >> variables? And in case of missing files: where can I get them? >> >> > > > All of this should be unnecessary. Just install the binary package from > http://pgfoundry.org/projects/dbdpgppm/ and all should be well. > > cheers > > andrew > > > _______________________________________________ > Dbdpg-general mailing list > Dbdpg-general@... > http://gborg.postgresql.org/mailman/listinfo/dbdpg-general > >