gleason Posted May 29, 2021 Share Posted May 29, 2021 If I supply certificates can you active SSL connection to postgres on tommy? Or can I only do this on my VPS if I host a postgres db? (trying to avoid putting one on my vps) Link to comment Share on other sites More sharing options...
wolstech Posted May 29, 2021 Share Posted May 29, 2021 I feel like someone else asked for this a while back and it couldn't be done, but I'll let Krydos take a look at it for you. Link to comment Share on other sites More sharing options...
Krydos Posted May 30, 2021 Share Posted May 30, 2021 (edited) I feel like someone else asked for this a while back and it couldn't be done, but I'll let Krydos take a look at it for you.Yeah, 2017 was the last time someone asked about this https://www.helionet.org/index/topic/28532-solved-enable-ssl-in-postgres-database/ It's definitely worth visiting again though since it's been 4 years. SSL has come a long way in that time so surely cpanel has fixed it right? Unfortunately, I have come to the same conclusion. The version of postgresql that cpanel packages does not have support for ssl compiled in. So I could just compile my own version of postgresql... but then you likely wouldn't be able to create postgresql databases through cpanel or use phppgadmin or anything. If there were any vulnerabilities or anything discovered I would have to recompile it again from source each time it needed to be upgraded. Sadly, it looks like you'll need a vps for this still. Nope, I think I got it to work! Try it now with sslmode=require Edited May 30, 2021 by Krydos tried some more Link to comment Share on other sites More sharing options...
Recommended Posts