Forum Discussion

dannyjump_14962's avatar
dannyjump_14962
Icon for Nimbostratus rankNimbostratus
Apr 08, 2014

PostgreSQL Monitor - but I need to connect with SSL

Hello,

 

I'm trying to setup an monitor on an 11.5 system, but its mandated that the connection has to be SSL enabled. I've taken packet captures and looked at the logs on the PostgreSQL node and can see the connection coming in, unfortunately they don't use SSL. Having hunted around the UI and 'Google' I thought I'd post a question here to the community?

 

Your help is much appreciated.

 

2 Replies

  • You have an impasse: you must use SSL in your monitor (by policy), but the host to be monitored doesn't implement SSL. You can either go for a policy variance or reconfigure the postgreSQL host.

     

  • In the monitor configuration, add "?ssl=true" to the end of the database field:

     

    Database: postgres?ssl=true

     

    If it's self-signed:

     

    Database: postgres?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory