How to install PyGreSQL (Python's PostgreSQL module)

[dblume]

Installing PyGreSQL isn't trivial, especially on Dell computers.  Here's a recipe that worked for me and Python 2.5:

1. Download and install postgresql-8.3.5-2-windows.exe  (You shouldn't need the whole install.)
2. Add C:\Program Files\PostgreSQL\8.3\lib to your PATH for libpq.dll.
3. Add C:\Program Files\PostgreSQL\8.3\bin to your PATH for ssleay32.dll.
4. Hide

Comments

[tpederson]

I just finished some dev work, but I used sqlite on my local machine, and as an added bonus found and used the SQLite manager extension in FireFox.

Mercifully, when it came time to move to the production server, our I.T. guy installed postgres. It's a linux/apache/Django setup, so the python db module was 'postgresql_psycopg2', so it was a different beast, but from what I understand it wasn't trivial either.

thanks for posting this

[anonymous]

I just got the first error you describe...what a disappointing mess!

I just fought PyGreSQL

[anonymous]

and I won! Finally, after renaming the libeay32.dll file as you suggested.
Damn what a PIA.

Dan

thanks

[anonymous]

Great, thanks. This really helped me. I have a Dell Desktop though and didn't have to hide the LIBEAY32.dll. Just adding the PostgreSQL BIN and LIB sub-dirs to my environment variable PATH worked.

[bothwill]

I get the same error every time I try to install the software. I should tell that I am not using a Dell, are these steps actually specific just for Dell computers? I even searched for more information on Microsoft dll files and I think I found a valuable track there. Is there any other resource you could share on this topic?