You can seamlessly protect the PostgreSQL cluster instances with multiple master/standby server instances. The cluster backup support for PostgreSQL allows to follow the master failover, and backup the data from cluster without any manual intervention.
note
-
In PostgreSQL, the database user must have superuser permissions to successfully perform cluster-level backups and restores using FSBasedBackupset. These permissions are crucial for establishing successful replication during the restore process.
-
The Cluster Backup feature is supported for PostgreSQL version 11 and above.
Pgpool Support to PostgreSQL Cluster
-
The Cluster Backup feature supports clusters configured with pgpool. During restore, the cluster must be restored with replication fully resumed. After restore, the pgpool status on the master node may appear as down. It occurs because both the nodes stop without any failover. To correct the pgpool status:
-
Edit the pgpool status file located at either:
-
/var/run/pgpool-II/pgpool_status
-
/var/run/pgpool/pgpool_status, and change the status from down to up for master node.
-
-
Restart pgpool
This behavior is expected only in failover command setups.
-