[pgpool-general: 7716] PGpool "recovery_1st_stage" script and integration with Barman wal archiver
Luca Maranzano
liuk001 at gmail.com
Sun Sep 26 22:17:57 JST 2021
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>
More information about the pgpool-general
mailing list