Enabling ssl certification validation

Deployment options: IBM Netezza Appliance

Learn how to enable ssl certification validation.

By default, the sslCertValidation option is disabled in postgresql.conf. To enable it, perform the following steps:
  1. Locate the postgresql.conf file in your PostgreSQL installation directory.
  2. Open the file using a text editor.
  3. Look for the line that contains sslCertValidation.
  4. Uncomment the line by removing the # symbol at the beginning.
  5. Change the value to true and save the file.
  6. Restart the PostgreSQL system for the changes to take effect.
  7. With this configuration, PostgreSQL will validate certificate expiry when accepting connections.