Adding a PostgreSQL Database Instance

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

Tip

If you have access to more than 10 server groups, use the arrow buttons at the lower-left bottom of the page to page through the server groups.

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

Before You Begin

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.

From the navigation pane, go to Servers > server > PostgreSQL. Then, in the middle of the page, click Add instance.

The Add PostgreSQL Instance dialog box appears.
In the Instance Name box, type the PostgreSQL instance name.
In the DB Username box, type the user name to access the PostgreSQL application.
In the Password box, type the PostgreSQL User Account Password.
In the Maintenance DB box, type the name of a system database which is used as a maintenance database.
In the Port box, type the port to open the communication between PostgreSQL Server and the clients.
In the Binary Directory box, type the path to the PostgreSQL application.
In the Lib Directory box, type the path to the library directory for the instance. For example, /opt/PostgreSQL/9.4/lib.
In the Archive Log Directory box, complete 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.
To delete the backed up log files after a backup operation, select the Archive Delete check box.
Click Add.

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

The software creates the instance.

Create subclients for the data that you want to protect.