How do I connect to Postgresql using SSL from SqlAchemy + pg8000?

Question

How do I connect to Postgresql using SSL from SqlAchemy + pg8000?

Connecting to postgres via pg8000 from SqlAlchemy worked fine until I enabled SSL on postgres.

db = create_engine('postgresql+pg8000://user:pass@hostname/dbname', echo=True).connect()

Now it seems to crash:

File "/Library/Python/2.7/site-packages/pg8000/core.py", line 872, in __init__
raise InterfaceError("communication error", exc_info()[1])
sqlalchemy.exc.InterfaceError: (InterfaceError) ('communication error', error(61, 'Connection refused')) None None

+1

python sqlalchemy pg8000

sorin 02 Aug 14 at 13:35

source to share

1 answer

Evgeny Prokurat · Accepted Answer · 2014-08-02T13:42:39+0000

maybe you need to add connect_args dict:

db = create_engine('postgresql+pg8000://user:pass@hostname/dbname', connect_args={'sslmode':'require'}, echo=True).connect()

How do I connect to Postgresql using SSL from SqlAchemy + pg8000?

More articles: