You must install the certificate for PostgreSQL when you enable TLS on localhost connections to PostgreSQL.
Procedure
- Copy the cert.pem file to /storage/db/vcops/vpostgres/data/server.key.
- Copy the cert.cert file to /storage/db/vcops/vpostgres/data/server.crt.
- Run the chmod 600 /storage/db/vcops/vpostgres/data/server.key command.
- Run the chmod 600 /storage/db/vcops/vpostgres/data/server.crt command.
- Run the chown postgres /storage/db/vcops/vpostgres/data/server.key and chown postgres /storage/db/vcops/vpostgres/data/server.crt commands to change the ownership of the server.crt and server.key files from root to postgres.