Creating PostgreSQL Cluster Client (Pseudo-client)

You can protect PostgreSQL data by creating PostgreSQL cluster client (pseudo-client). The PostgreSQL cluster client allows to add a standby or master server instance on which you want to offload backup and restore operations.

Note

You can add master and standby server instances while creating the PostgreSQL cluster client.

Before You Begin

Install the PostgreSQL agent, both on the master server and the standby server.

For more information, see Deployment - PostgreSQL Agent.
Configure the archive command and archive_mode on both master and standby servers.
```
For Example: 

 archive_command = 'cp %p /opt/wal/%f' #UNIX

 archive_command = 'copy "%p" "D:\\PostgreSQL\\wal\\%f"' #Windows

 archive_mode = always
```
It is recommended to set archive_mode to always for backup from standby server. It ensures that the backup of new logs are generated between the log backup and failover, on master server.
Set wal_log_hints to on in the configuration file or enable data checksums during cluster initialization. You must configure these settings during backup to perform restore to a particular time.

Procedure

From the CommCell Browser, go to Client Computers.
Right-click the Client Computers, and then click New Clients.

The Add New Client dialog box appears.
From the Application section, click PostgreSQL cluster client.

The Create PostgreSQL cluster client dialog box opens.
In the General tab, do the following:
- Cluster name: Enter a name for the PostgreSQL cluster client.
- Cluster Type: Select a required cluster type from the Cluster Type drop-down list.
  Note
  
  We support the following four cluster types:
  - Patroni HA
  - EDB Failover Manager
  - Repmgr for Postgres
  - Native Replication
  Select Native Replication when no third party is available to manage the replication or failover.
- Storage policy: Select a suitable storage policy from the Storage Policy drop down list.
In the Details tab, do the following:
1. Add, modify and delete PostgreSQL instance.
2. To run a backup operation from the master server if none of the standby servers are available, select the Use master if standby is unavailable check box.
3. To run a log backup operation from the master server, select the Always use master for log backup check box.
4. Select the Archive Delete checkbox to delete the Archive logs after the successful backups.
  
  Note
  
  The selection made for Use master if standby is unavailable, Always use master for log backup and Archive Delete will be applicable for all the added master or standby instances.
Click OK.