When using SQLDB to open a connection to a PostgreSQL database, there is currently no way to select the SSL Mode of the connection.
Attached is a patch file which allows the sslmode to be optionally selected for non-jdbc Postgres connections via the following URL style: postgres://user:passw...@host:port/database?sslmode=require. The related PostgreSQL documentation page is located here: http://www.postgresql.org/docs/8.4/static/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS. In the documentation you will see that the default value for sslmode is prefer. If the sslmode is not specified, the patch will default to prefer. In this way I believe the patch is backward compatible. Regards, Josh Jaques This communication, including any attachments, does not necessarily represent official policy of Seccuris Inc. Please see http://www.seccuris.com/Contact-PrivacyPolicy.htm for further details about Seccuris Inc.'s Privacy Policy. If you have received this communication in error, please notify Seccuris Inc. at i...@seccuris.com or at 1-866-644-8442.
sql.py.POSTGRES_SSL.patch
Description: sql.py.POSTGRES_SSL.patch