You must edit the postgresql.conf file to activate TLS on localhost connections to PostgreSQL.

Procedure

  • Edit the postgresql.conf file at /storage/db/vcops/vpostgres/data/ and make the following changes:
    1. Set ssl = on.
    2. Set ssl_cert_file = 'server.crt'.
    3. Set ssl_key_file = 'server.key'.