Hi there!
I want to ask about postgresql with ssl. is anyone here have been try to use postgresql 14 cluster (that run on patroni and etcd) and also using ssl?
Or if not, does anyone build and use postgresql with ssl generally? Cause I wonder, about the SSL in the postgresql
Thank you
Hi @ramadhaniawy, SSL is a regular part of PostgreSQL, yes. You can have more information on how to secure your server in the following blog posts from my colleague Jobin:
Note that etcd can also be configured with TLS (settings ETCD_KEY_FILE and ETCD_CERT_FILE).
I hope this helps!
Dear Laudares,
Thank you, I’ll try it. Anyway, I also wonder, since I use postgresql cluster, I do have load balancer (haproxy). In haproxy, there are 3 mode of SSL, Client-side encryption, OCSP stapling, and Server-side encryption (SSL/TLS | HAProxy config tutorials)
Have you ever try to made the SSL is run in the client side encryption only? So the patroni and etcd will still use the non ssl connection.
Thank you