building psycopg2 on windows using mingw, "cannot find -lpq"

[GHUM]

The compile works, BUT linking fails:

2.5\Release\psy copg\_psycopg.d ef -Lc:\python25\li bs -Lc:
\python25\PCBui ld -Lc:/p
ostgres/83RC2/lib -lpython25 -lpq -lws2_32 -ladvapi32 -o build
\lib.win32-2.5\psy
copg2\_psycopg. pyd
c:\mingw\bin\.. \lib\gcc\mingw3 2\3.4.5\..\..\. .\..\mingw32\bi n\ld.exe:
cannot find -lpq
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

if I google for the error

"ld.exe: cannot find -lpq"

there is allways the information that the lib-dir of libpq is missing;
but :

-Lc:/postgres/83RC2/lib

is clearly in the commandline, and within c:/postgres/83RC2/lib
there is one libqp.lib

What am I missing? any hints?

Best wishes,

Harald

(complete output:
c:\mingw\bin\gc c.exe -mno-cygwin -shared -s build
\temp.win32-2.5\Release\psy copg
\psycopgmodule. o build\temp.win3 2-2.5\Release\psy copg\pqpath.o build
\temp.win32-
2.5\Release\psy copg\typecast.o build\temp.win3 2-2.5\Release\psy copg
\microprotoco
ls.o build\temp.win3 2-2.5\Release\psy copg\microproto cols_proto.o build
\temp.win3
2-2.5\Release\psy copg\connection _type.o build\temp.win3 2-2.5\Release
\psycopg\con
nection_int.o build\temp.win3 2-2.5\Release\psy copg\cursor_typ e.o build
\temp.win3
2-2.5\Release\psy copg\cursor_int .o build\temp.win3 2-2.5\Release\psy copg
\lobject_
type.o build\temp.win3 2-2.5\Release\psy copg\lobject_in t.o build
\temp.win32-2.5\R
elease\psycopg\ adapter_qstring .o build\temp.win3 2-2.5\Release\psy copg
\adapter_pb
oolean.o build\temp.win3 2-2.5\Release\psy copg\adapter_bi nary.o build
\temp.win32-
2.5\Release\psy copg\adapter_as is.o build\temp.win3 2-2.5\Release\psy copg
\adapter_
list.o build\temp.win3 2-2.5\Release\psy copg\adapter_da tetime.o build
\temp.win32-
2.5\Release\psy copg\_psycopg.d ef -Lc:\python25\li bs -Lc:
\python25\PCBui ld -Lc:/p
ostgres/83RC2/lib -lpython25 -lpq -lws2_32 -ladvapi32 -o build
\lib.win32-2.5\psy
copg2\_psycopg. pyd
c:\mingw\bin\.. \lib\gcc\mingw3 2\3.4.5\..\..\. .\..\mingw32\bi n\ld.exe:
cannot find -lpq
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
)

[Tom Brown]

On Mon, 2008-01-21 at 01:57 -0800, GHUM wrote:

What am I missing? any hints?

I use psycopg2 all the time on windows. I use the binary installer
instead of source. Works great for me.

-Tom

[Diez B. Roggisch]

GHUM wrote:

The compile works, BUT linking fails:

2.5\Release\psy copg\_psycopg.d ef -Lc:\python25\li bs -Lc:
\python25\PCBui ld -Lc:/p
ostgres/83RC2/lib -lpython25 -lpq -lws2_32 -ladvapi32 -o build
\lib.win32-2.5\psy
copg2\_psycopg. pyd
c:\mingw\bin\.. \lib\gcc\mingw3 2\3.4.5\..\..\. .\..\mingw32\bi n\ld.exe:
cannot find -lpq
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

if I google for the error

"ld.exe: cannot find -lpq"

there is allways the information that the lib-dir of libpq is missing;
but :

-Lc:/postgres/83RC2/lib

is clearly in the commandline, and within c:/postgres/83RC2/lib
there is one libqp.lib

What am I missing? any hints?

Are you sure using forward slashes in the path works here?

Diez

[GHUM]

The compile works, BUT linking fails:

>

2.5\Release\psy copg\_psycopg.d ef -Lc:\python25\li bs -Lc:
\python25\PCBui ld -Lc:/p
ostgres/83RC2/lib -lpython25 -lpq -lws2_32 -ladvapi32 -o build

*-Lc:/postgres/83RC2/lib

Are you sure using forward slashes in the path works here?

Not at all. But that commandline is generated by setup.py, not by me :
(
and setup.py extracts the paths from pg_config

so: I have no idea how to make it use backslash :(

Thanks for the idea,

Harald

[GHUM]

I use psycopg2 all the time on windows. I use the binary installer

instead of source. Works great for me.

-Tom

Me2. Just in 7 out of 200 it does not work with the currently
available binary installer, on some startups, so I decided to follow a
recommendation out of the psycopg2 list to compile it from trunk :(

Harald