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 .. Thank you Krishane Please 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=y repo2-path=/var/lib/ Server_2_Backup repo2-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_Backup repoN-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 ###################################################################
