[pgpool-general: 7716] PGpool "recovery_1st_stage" script and integration with Barman wal archiver

[Luca Maranzano]

Hi all,

we setup a 3 nodes cluster with PGPool-II version 4.2.3 on 3 physical
servers with CentOS 7 and PostgreSQL 12.8, like described here:
https://www.pgpool.net/docs/latest/en/html/example-cluster.html

The above procedure says to configure archiving with this command:

archive_command = 'cp "%p" "/var/lib/pgsql/archivedir/%f"'

but since we setup also Barman to perform Backup with Zero Data loss, the
archive commandmust be this one:
archive_command = '/usr/bin/barman-wal-archive  BARMAN_HOST SERVER_NAME  %p'

so WALs get archived continuously by the barman process.

In the "recovery_1st_stage" script that is used by pgpool to implement
failover and restore, there are these references to the Archivedir:
ARCHIVEDIR=/pgprdarch
    rm -rf $ARCHIVEDIR/*
restore_command = 'scp ${PRIMARY_NODE_HOST}:${ARCHIVEDIR}/%f %p'

So my question is: which is the correct way to integrate Barman Wal
archiving with PGPool-II recovery feature?

Thanks in advance
Regards
Luca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210926/b208e2e1/attachment.htm>