Hi
On Mon, Jul 22, 2024 at 9:35 AM KK CHN <kkchn.in@xxxxxxxxx> wrote:
Hi list ,I am exploring the PgBackRest tool for production deployment. ( My lab setup with one Database server and another Reposerver deployed working fine as in the official docs)Query:What may be the standard practice employed to backup multiple production servers to one RepoServer ? ( the pgbackrest configuration on the RepoServer part )Is this the right way to achieve this (Defining multiple stanzas Server1, Server 2 .. Server N and single [global] with repo1, repo2 and repon N declarations ?Please correct me if I am wrong ..
Yes , normally there is one repo server which contains the configuration of all DB Servers in form of stanzas.
Regards
Kashif Zeeshan
Thank youKrishanePlease find the proposed pgbackrest.conf in the RepoServer for backing up multiple database servers./etc/pgbackrest/pgbackrest.conf on RepoServer##################################################[ Server _1]pg1-host=10.20.20.6
pg1-host-user= pgbackUser
pg1-path=/var/lib/pgsql/16/data. . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . .. .. . .. . . . .[ Server _N]pgN-host=10.20.20.N
pgN-host-user= pgbackUser
pgN-path=/var/lib/pgsql/16/data[global]repo1-path=/var/lib/ Server_1_Backup
repo1-retention-full=2
repo1-cipher-type=aes-256-cbc
repo1-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
process-max=5
log-level-console=info
log-level-file=debug
start-fast=y
delta=y
repo1-block=y
repo1-bundle=yrepo2-path=/var/lib/ Server_2_Backuprepo2-retention-full=2
repo2-cipher-type=aes-256-cbc
repo2-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
process-max=5
log-level-console=info
log-level-file=debug
start-fast=y
delta=y
repo2-block=y
repo2-bundle=y. . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . .repoN-path=/var/lib Server_N_BackuprepoN-retention-full=2
repoN-cipher-type=aes-256-cbc
repoN-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
process-max=5
log-level-console=info
log-level-file=debug
start-fast=y
delta=y
repoN-block=y
repoN-bundle=y[global:archive-push]
compress-level=3###################################################################