Re: [ClusterLabs] backup of postgres database from cluster

2022-03-05 Thread Jehan-Guillaume de Rorthais
Hi, On Wed, 2 Mar 2022 14:39:40 +0100 damiano giuliani wrote: > ... > 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? The new primary is supposed to archive WALs to your backup server. > would I sti

[ClusterLabs] backup of postgres database from cluster

2022-03-02 Thread 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 u