[ClusterLabs] PAF / PGSQLMS and wal_level ?

[lejeczek]

On 08/09/2023 17:29, Jehan-Guillaume de Rorthais wrote:
> On Fri, 8 Sep 2023 16:52:53 +0200
> lejeczek via Users <users at clusterlabs.org> wrote:
>
>> Hi guys.
>>
>> Before I start fiddling and brake things I wonder if
>> somebody knows if:
>> pgSQL can work with: |wal_level = archive for PAF ?
>> Or more general question with pertains to ||wal_level - can
>> _barman_ be used with pgSQL "under" PAF?
> PAF needs "wal_level = replica" (or "hot_standby" on very old versions) so it
> can have hot standbys where it can connects and query there status.
>
> Wal level "replica" includes the archive level, so you can set up archiving.
>
> Of course you can use barman or any other tools to manage your PITR Backups,
> even when Pacemaker/PAF is looking at your instances. This is even the very
> first step you should focus on during your journey to HA.
>
> Regards,
and with _barman_ specifically - is one method preferred, 
recommended over another: streaming VS rsync - for/with PAF?
many thanks, L.