Loading...

Managing PostgreSQL Database Instances

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:

  • DumpBasedBackupSet
  • FSBasedBackupSet

Before You Begin

Make sure that you have the following information:

  • The PostgreSQL application path and library directory path
  • The credentials that you use to access the PostgreSQL application
  • The storage policy to use for log backups
  • 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. You can add an instance from the agent details page. You can edit an instance from the instance details page.
    • Agent details: From the navigation pane, click Servers > server > PostgreSQL. Then, in the middle of the page, click Add instance.

      The Add PostgreSQL Instance dialog box appears.

  2. In the Instance Name box, type the PostgreSQL instance name.
  3. In the DB Username box, type the user name to access the PostgreSQL application.
  4. In the Password box, type the PostgreSQL User Account Password.
  5. In the Maintenance DB box, type the name of a system database which is used as a maintenance database.
  6. In the Port box, type the port to open the communication between PostgreSQL Server and the clients.
  7. In the Binary Directory box, type the path to the PostgreSQL application.
  8. In the Lib Directory box, type the path to the library directory for the instance. For example, /opt/PostgreSQL/9.4/lib.
  9. 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.

  10. To delete the backed up log files after a backup operation, select the Archive Delete check box.
  11. Click Add.

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

Result

The software creates the instance.

What to Do Next

Create subclients for the data that you want to protect.

Last modified: 3/1/2018 7:45:57 PM