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.
Additionally, the PostgreSQL cluster backup is managed by a single cluster client (pseudo-client) that handles the failover between server instances.
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 restoration process.
-
This feature is supported for PostgreSQL version 11 and above.