Adding a PostgreSQL Instance

Add a PostgreSQL instance when you need to manage a database.

When you add an instance, the following backup sets are automatically created, each with a default database group:

• DumpBasedBackupSet

• FSBasedBackupSet

Before You Begin

• Verify the connection to the PostgreSQL database server.

• Obtain the PostgreSQL application path and library directory path.

• Obtain the credentials that you use to access the PostgreSQL application.

• Make sure that you have a storage policy to use for log backups.

• Configure the PostgreSQL archive log directory.

  For more information, see Configuring the PostgreSQL Archive Log Directory.

• Optional: If you want to use a specific account when you perform backup and restore operations, have the user name and the password.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The database Overview opens.

2. From the Add instances list, select Database server.

   The Configure Database Instance dialog box appears.

3. Select PostgreSQL.

   The Add PostgreSQL instance dialog box appears.

4. From the Server name list, select a server where you want to create the new instance.

5. In the Instance Name box, type the PostgreSQL instance name.

6. From the Plan list, select a backup plan.

7. Under Connection details section, enter the following information:

   1. From Credential list, select an existing credential or add a new credential. To add a new credential, do the following:

      Steps to add a credential

      1. Click +.

         The Add Credential dialog box appears.

      2. From the Account type list, select a database account type.

      3. From the Database credential type, select a database agent.

      4. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

      5. In the Credential name box, enter a unique name to access the credential.

      6. Under the Azure AD/AWS IAM Authentication section, enter the following details:

         • In the Username box, enter the user name to access the Azure Database for PostgreSQL application.

         • In the Password box, enter the password to access the Azure Database for PostgreSQL application.

         Note

         If you move the Azure AD/AWS IAM Authentication toggle to right, you only need to enter the user name detail.

      7. Move SSL certificate toggle key to right, and enter the following details:

         • In the SSL CA file field, provide the SSL CA file path on the proxy computer.

         • In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.

         • In the SSL Key file field, provide the SSL key file path on the proxy computer.

      8. In the Description box, enter a brief description for the credential.

      9. Click Save.

   2. In the Maintenance DB box, type the name of a system database which is used as a maintenance database.

   3. In the Port box, type the port to open the communication between PostgreSQL Server and the clients.

      • If you are using the same port number for two or more instances, you can type the port number in the IP:PORT format.

        For example: You can type the port number as 10.57.198.4:5432, if the IP for your Network Interface Card (NIC) is 10.57.198.4 and you are using port 5432. To use the same port number on a different NIC, you can type 10.57.198.5:5432.

      • If you are using the custom socket directory, enter the port in the SOCKET_DIR_PATH:PORT format.

        For example: If socket directory used is /var/run/postgresql and you are using port 5432, enter the port as /var/run/postgresql:5432.

      • If you are configuring a containerized PostgreSQL instance, enter the port in HOSTNAME:PORT format or IP:PORT format.

8. Under PostgreSQL paths section, enter the following information:

   1. In the Binary directory box, type or browse the path to the PostgreSQL application.

   2. In the Lib directory box, type or browse the path to the library directory for the instance.

      For example, /opt/PostgreSQL/9.4/lib.

   3. In the Archive log directory box, complete one of the following steps:

      • On a UNIX client, type the path to the directory where you want to store the archive log files. For example, /opt/wal. Make sure that this path does not point to pg_log and pg_xlog directories.

      • On a Windows client, type the path to the directory where you want to store the archive log files.

      Note

      The Archive log directory is required only for running fs-based backups for the instance. It is not required if you plan to run only dump-based backups.

9. Click Add.

   The software creates the instance and a default database group for DumpBasedBackupSet and FSBasedBackupSet.

What to Do Next

Create database groups for the data that you want to protect.