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
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? |