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 navigation pane, go to Protect > Databases > DB Instances.

2. Click Add instance, and then select PostgreSQL.

   The Add PostgreSQL instance dialog box appears.

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

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

5. From the Plan list, select a server plan.

6. Under Connection details, enter the following information:

   1. In the Database user box, type the user name to access the PostgreSQL application.

   2. In the Password box, type the PostgreSQL user account password.

   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.

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

7. Under PostgreSQL paths, 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.

8. Click Add.

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

   Note

   For Dumpbased backupset, associating a database group to a backup plan will only associate a storage policy, and not a schedule policy. To associate a schedule policy, edit the instance and move the Run dump backups with plan-based schedules toggle key to the right. This will disable schedule policy for FSBased backupset.

What to Do Next

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