Documentation forDatabase Performance Analyzer

Manage DB certificates

A DB certificate is associated with a specific PostgreSQL or EDB Postgres database instance, and DPA can use it to connect to that instance. DB certificates are used only by DPA, and they are stored in the DPA repository database.

You can use DPA to view information about DB certificates, import a DB certificate and associate it with a database instance, or remove a DB certificate.

View information about DB certificates

  1. On the DPA menu, click Options.

  2. Under Administration > Configuration, click Trusted Certificate Management.

    The Trusted Certificate Management page opens.

  3. Click DB Certificates.

    The DB Certificates tab lists all PostgreSQL or EDB Postgres database instances monitored by DPA. Instances that are associated with a DB certificate have a certificate icon next to the name, and information about the certificate is displayed.

  4. You can:

    • Sort by database instance name, subject, issuer, or expiration date. Click the down arrow to select the attribute you want to sort by. Click the sort button to reverse the sort order.

    • Enter a string in the search field to find database names, subjects, or certificates that include the string. The list is filtered to show only database instances that meet the search criteria.

    • Click the arrow on the right to view certificate details.

      The Certificate Details panel opens. Click a link at the bottom to view or copy the certificate text.

Import a DB certificate and associate it with a PostgreSQL database instance

When you import a certificate through the DB Certificates tab, the certificate is stored in the DPA repository database. It is associated with one or more PostgreSQL database instances during the import process, and DPA uses it to connect to those instances.

  1. Open the DB Certificates tab.

  2. Select the database instances you want to associate with a certificate.

    The Set certificate and Remove certificate buttons are displayed.

  3. Click Set certificate.

    The Import certificate file dialog box opens.

  4. Click Browse and select the certificate file.

  5. Click Import.

    The certificate is imported and associated with the selected database instances.

Remove a DB certificate

You can disassociate a DB certificate from a database instance and remove it from the DPA repository database. For example, you can remove a certificate when it expires.

  1. Open the DB Certificates tab.
  2. Select the database instances that are associated with certificates you want to remove.

    The Set certificate and Remove certificate buttons are displayed.

  3. Click Remove certificate, and then click Remove on the confirmation dialog box.

    The selected database instances no longer have certificates associated with them, and the certificates are removed from the DPA repository database.