You can run full backup operation on both FSBasedBackupSet and DumpBasedBackupSet from the cluster client. You can also run log backups from FSBasedBackupSet.
The backup operations are similar to traditional instances. For more information, see traditional backup.
The IntelliSnap Backups and Block-Level Backups are also supported.
Note
-
For DumpBasedbackupSet, the backup operation always runs on the first available standby node.
-
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.
-
The FSBased backup runs on the first available standby server instance. The data backup phase identifies the standby server instance based on the priority order, and the log backup is performed depending on archive_mode value.
-
For streaming replication, if archive_mode is set to on, the log backup will be performed on the master node. If archive_mode is set to always, the log backup will be performed on the standby node by default.
-
For log shipping type, the log backup will be performed on the standby node by default.
-
If you select Always use master for log backup option, the log backup is performed from the master node irrespective of the value set for archive_mode.
-
It is recommended to set archive_mode to always to ensure point-in-time restore of data between the last log backup and failover (if any).
-
If you select Always use master for Dump Based Backup option, the DumpBased backup is always performed from the master node.