psycopg2 error with QGIS 1.5

Question

So I just installed QGIS 1.5 using the windows installer not the osgeo4w one and now any plugins that need access to PostgreSQL databases don't seem to work, they all throw a:

"Couldn't import Python module 'psycopg2' for communication with PostgreSQL database. Without it you won't be able to run xxxxx. Please install it."

My current environment variables look like:

PATH=C:\WINDOWS\system32;
C:\WINDOWS;
C:\WINDOWS\System32\Wbem;
C:\Program Files\TortoiseSVN\bin;C:\Program Files\Mercurial\;
C:\Program Files\Console2;
C:\WINDOWS\system32\WindowsPowerShell\v1.0;
C:\Program Files\Git\bin;
C:\Program Files\Git\cmd;
C:\Program Files\Quantum GIS Tethys\apps\qgis\bin;
C:\Program Files\IronRuby 1.1\bin;
C:\Program Files\Quantum GIS Tethys\bin;

and PYTHONPATH is set to:

PYTHONPATH=C:\Program Files\Quantum GIS Tethys\apps\qgis\python

I used to have version 1.4 installed and I noticed that in the python folder for 1.4 there was a folder and file called psycopg2_psycopg.pyd, but if I take that file and put it in the python path for 1.5 it still doesn't work (didn't think it would but was worth a try)

I downloaded and tried to install psycopg2-2.2.2.win32-py2.4-pg8.4.4-release.exe which is the latest verstion of psycopg2 but because have the python that is installed with QGIS it throws a "Python 2.4 not in registry error".

Anyone know how I can get this version of QGIS running with psycopg2?

Answer 1

Firest, are you sure about the version of your Python? From Osgeo4w you should have installed Python 2.5. Second, from the same installer, under Libs, you have the option to install psycopg2 too.

Otherwise, if you want to install modules thorugh their own windows installer, you have to put the needed registry values. They're set when you install Python by yourself, while the osgeo4w installer keeps your system clean to do not override your settings... That's why the psycopg2 installer complains it can't find the registry values.

you can put the following lines into a "youfile".reg file, and load it from the registry to have the needed values set:

[HKEY_LOCAL_MACHINE\SOFTWARE\Python]

[HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore]

[HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore\2.5]

[HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore\2.5\InstallPath] @="C:\OSGeo4W\apps\Python25"

[HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore\2.5\PythonPath] @="C:\OSGeo4W\apps\Python25\Lib;C:\OSGeo4W\apps\Python25\DLLs;C:\OSGeo4W\apps\Python25\Lib\lib-tk"

giovanni