> CommCell Console > Backup and Restore Agents > Databases > PostgreSQL > Cluster Backup Support for PostgreSQL > Creating PostgreSQL Cluster Client (Pseudo-client)

Adding a PostgreSQL Instance

You can add master or standby server instances.

Procedure

The Details tab is open.

  1. Click Add.

    The Create Instance Property dialog box opens.

  2. In the Instance Physical Client box, select an instant physical client from dropdown list.

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

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

  5. In the Port box, type or select the port to open the communication between PostgreSQL Server and the clients.

  6. In the Binary Directory box, type the path to the Postgres application. Alternatively, click Browse to locate the path.

  7. In the Library Directory box, type the path to the library directory for the instance. For example, /usr/PostgreSQL/9.2/lib. Alternatively, click Browse to locate the path.

  8. In the Archive Log Directory box, type the path of 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.

    For more information, see Configuring the PostgreSQL Archive Log Directory.

  9. In the Cluster binary path box, type the path of the third party cluster type bin directory. Alternatively, click Browse to locate the path.

  10. In the Cluster Config File, enter the path of the cluster configuration file. Alternatively, click Browse to locate the path. Example:

    • For patroni HA: /etc/patroni/patroni.yaml

    • For Repmgr: /etc/repmgr/repmgr.conf

    • For EFM: /etc/edb/efm-4.4/efm.properties

    Note

    If Native Replication is selected as cluster type, the Cluster binary path and Cluster Config File options will not be available.

  11. Click OK.

    The added master and standby server instance list is displayed.

×

Loading...