PostgreSQL over TLS

Tiny Tiny RSS
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 PostgreSQL: Documentation: 9.5: SSL Support 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.