How to import certificates for monitoring Postgres Server with SSL authentication?

How to import certificates for monitoring Postgres Server with SSL authentication?

Before adding a PostgreSQL server that requires SSL authentication, you must import the server's SSL certificates into the Applications Manager trust store (cacerts) to establish a secure connection. Attempting to add without import might give connection attempt failed error.

Solution:
      To import certificates, login as admin user and follow the steps given below:
  1. Navigate to Settings tab --> under Tools section --> choose Manage Certificates.
  2. Click on the "Trust Certificates" sub tab. Here you have 3 options to import certificates into trusted sources.
  3. Choose the Certificate option --> Under Choose truststore, Select cacerts and upload required Server Certificate files.
Notes
Note:
  1. For CA-Signed Certificates: You only need to import the Server certificate only.
  2. For Self-Signed Certificates: You must import both the Server certificate and the Root certificate.
  3. Applications Manager supports .cer, .crt, and .der certificate file formats.