C:\Users\grant>pip install psycopg2-binary
Collecting psycopg2-binary
Downloading psycopg2_binary-2.7.4-cp27-cp27m-win32.whl (859kB)
100% |################################| 860kB 882kB/s
Installing collected packages: psycopg2-binary
Successfully installed psycopg2-binary-2.7.4
You are using pip version 9.0.1, however version 10.0.0 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.
C:\Users\grant>python
Python 2.7.10 (default, May 23 2015, 09:40:32) [MSC v.1500 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2
>>> psycopg2.connect( 'postgresql://localhost/postgres?gsslib=gssapi' )
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:\Python27\lib\site-packages\psycopg2\__init__.py", line 129, in connect
dsn = _ext.make_dsn(dsn, **kwargs)
File "C:\Python27\lib\site-packages\psycopg2\extensions.py", line 155, in make_dsn
parse_dsn(dsn)
psycopg2.ProgrammingError: invalid dsn: invalid URI query parameter: "gsslib"
C:\Users\grant>python --version
Python 2.7.10
C:\Users\grant>ver
Microsoft Windows [Version 10.0.16299.371]
I am speculating here, but perhaps the libpq library that was used to build the package was not built using the --with-gssapi switch described here?