Windows binary install and gssapi support

From: Grant McKenzie <grant(dot)r(dot)mckenzie(at)gmail(dot)com>
To: psycopg(at)lists(dot)postgresql(dot)org
Subject: Windows binary install and gssapi support
Date: 2018-04-15 00:35:29
Message-ID: CAEDmdPLrBS_tHzPhfFEGpjO9sDoimTTCyHvoR7Qme+1-2q3EJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello,

Postgres supports a connection string parameter 'gsslib'. This is
documented here:

https://www.postgresql.org/docs/current/static/libpq-connect.html

When I install the psycopg2 binary distribution on windows, I see the error
below.

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?

https://www.postgresql.org/docs/10/static/install-procedure.html

Thanks

Responses

Browse psycopg by date

  From Date Subject
Next Message Jason Erickson 2018-04-15 02:28:45 Re: Windows binary install and gssapi support
Previous Message Joe Abbate 2018-03-26 23:36:45 Re: BC date getting misinterpreted?