Re: No library found for -lpq

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:
> [email protected] 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
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/dbdpg-general
>
>