CODEWITHSUNDEEP
pythondjangopostgresqlpsycopg2
Jerry
Jerry

Reputation:

psycopg2 on cygwin: no such process

I am trying to install postgrepsql to cygwin on a windows 7 machine and want it to work with django.

After built and installed postgrepsql in cygwin, I built and installed psycopg2 in cygwin as well and got no error, but when use it in python with cygwin, I got the "no such process" error:

import psycopg2 Traceback (most recent call last): File "", line 1, in File "/usr/lib/python2.5/site-packages/psycopg2/init.py", line 60, in from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID ImportError: No such process

any clues?

Thanks!

Jerry

Upvotes: 0

Views: 1283

Answers (4)

Tony
Tony

Reputation: 625

In my case, I had to reinstall libpq5.

Upvotes: 1

Zakk Acreman
Zakk Acreman

Reputation: 11

The no such process error comes about because psycopg2 is looking for cygpq.dll and can't find it.

When you install postgres from source, it puts this .dll in /usr/local/pgsql/lib/

Evidently, cygpq.dll is resolved by the win32 process loader, NOT cygwin or python, so you have to put it somewhere on your Windows path. A good spot is /usr/local/bin.

cp /usr/local/pgsql/lib/cygpq.dll /usr/local/bin/

Upvotes: 1

Jay
Jay

Reputation: 702

you could try these: http://www.stickpeople.com/projects/python/win-psycopg/

Upvotes: 0

Joshua D. Drake
Joshua D. Drake

Reputation: 1012

Why? There is native psycopg2 for Win.

Upvotes: 0

Related Questions