Adding a PostgreSQL Instance

Updated

Add 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 database group:

  • DumpBasedBackupSet

  • FSBasedBackupSet

Before You Begin

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.

    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.

What to Do Next

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