[Sqlalchemy-tickets] Issue #4146: common handling of `sslmode` and `sslrootcert` URL params for pg8000 (zzzeek/sqlalchemy)

[Glyph <iss...@bi...>]

New issue 4146: common handling of `sslmode` and `sslrootcert` URL params for pg8000
https://bitbucket.org/zzzeek/sqlalchemy/issues/4146/common-handling-of-sslmode-and-sslrootcert

Glyph:

In order to ensure a secure connection with psycopg2, you can add `sslmode=verify-full&sslrootcert=rds.root.pem`.

However, these parameters will be ignored with pg8000 which may result in an insecure connection when a secure one is expected.

It would be nice if these parameters were handled consistently so postgres users could switch drivers without getting tripped up by this nuance.

Unfortunately only `sslmode` can be implemented right now, as `sslrootcert` requires support from pg8000 itself; filed here https://github.com/mfenniak/pg8000/issues/148