PostgreSQL over TLS


#1

Is there a way to enable postgresql connection over SSL? I’m looking for to enable encypted connections, but I’m not seeing a way. If possible, what do I do. If it isn’t possible, can we get an enhancement for it?


#2

You can append ;sslmode=require to the DB_HOST in config.php:

define('DB_HOST', 'localhost;sslmode=require');

See https://www.postgresql.org/docs/9.5/static/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS for the valid sslmode options. To test that it actually works, you can also try an invalid mode like

define('DB_HOST', 'localhost;sslmode=doesntwork');

and get the appropriate error message when you reload tt-rss in the browser.


#3

Thanks for the info. I’ll give it a try.