[ClusterLabs] backup of postgres database from cluster

[damiano giuliani]

Hello everybody,

I would need some clarification regarding the backup system I was asked to
implement.
the current configuration is as follows:
3 servers where a postgres cluster with PAF
1 server where the backup and its incrementals must be stored

my idea is to use pg_basebackup and then back up the respective WAL logs to
have an incremental backup.
my question is: what happens in case of failover of the master on another
node to the wal logs that i am archiving to build the incrementals?
obviously the backup server will take the incrementals always pointing to
the VIP.

would I still have a consistent backupset in case of a node failover?

thank you

Damiano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20220302/6d96f16b/attachment.htm>