I have configured SSL parameter set to ON in GP 5.29. How do I let the client to connect greenplum using ssl connection? Do I have to set hostssl for that specific connection in pg_hba.conf file? Do you have any uise case document on this?

[Melwin Singaram]

 

[Kevin Huang]

Yes you should use hostssl in pg_hba.conf file. The Greenplum docs describe how to set it up:

 

https://docs.vmware.com/en/VMware-Greenplum/5/greenplum-database/security-guide-topics-Authenticate.html?hWord=N4IghgNiBcIM5ygXyA#topic_ibc_nl2_jr