[Sqlalchemy-tickets] Issue #3153: postgresql+pg8000 fails to connect when postgresql server is using SSL (zzzeek/sqlalchemy)

[Sorin S. <iss...@bi...>]

New issue 3153: postgresql+pg8000 fails to connect when postgresql server is using SSL
https://bitbucket.org/zzzeek/sqlalchemy/issue/3153/postgresql-pg8000-fails-to-connect-when

Sorin Sbarnea:

postgresql+pg8000 fails to connect when postgresql server is using SSL

pg8000/core.py", line 873, in __init__
    raise InterfaceError("communication error", exc_info()[1])
sqlalchemy.exc.InterfaceError: (InterfaceError) ('communication error', error(61, 'Connection refused')) None None

I even tried to use the same parameter as the one used in the psycopg2 and to append '&sslmode=require" to the URL but this has no effect.

pg8000 has a parameter for enabling SSL, but this seems not to be supported by sqlalchemy or not documented.

In fact the proper way to implement this would be to use SSL without having to ask for an additional parameter. A very good example is "psql" utility which works in both cases, without asking you to specify if is to use SSL or not.