Adding a New PostgreSQL Instance

You can add a new PostgreSQL instance.

Before You Begin

Verify the PostgreSQL database server connection.

Procedure

1. From the CommCell Browser, navigate to Client Computers | <Client>.

2. Right-click PostgreSQL, point to All Tasks, and then click New PostgreSQL Instance.

3. In the Instance Name box type the PostgreSQL instance name.

4. Click the Credential list, and then click Create New to add a new credential.

5. In the Maintenance DB box, type the name of the Maintenance Database.

6. In the Binary Directory box, type the path to the Binary directory. Alternatively, click Browse to select the path.

7. In the Lib Directory box, type the path to the Library directory. Alternatively, click Browse to select the path.

8. In the Archive Log Directory box, type the path to archive log directory that is configured for the server.

   For example, in postgresql.conf file, if archive_command is cp %p /opt/wal/%f, then provide the archive log directory path as /opt/wal.

   We validate this path with the archive log directory path in the postgresql.conf file.

   Note

   • If you want to run only dump based backup and restore operations, it is not mandatory to configure the archive log directory.

   • It is good to not have archive log directory inside the data directory.

9. In the Port box, type or select the port number.

   • 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.

10. In the Log Backup Storage Policy box, type or select the storage policy.

11. Click OK.

For instructions on adding the additional setting from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.