If your PostgreSQL instance uses SSL connections, you must complete the following steps to monitor it.
Download PEM file from Amazon and copy to a local directory.
Convert the PEM file to a DER file using the following openssl command:
Add the certificate to the Java keystore using the following command:
You can verify that the certificate was added by running the following command:
- Re-start the dbagent process to register the certificate you added.
In the Controller, create a new collector for PostgreSQL. In the Custom JDBC Connection String field, enter the following JDBC string: