Hi On Mon, Jul 22, 2024 at 9:35 AM KK CHN <kkchn...@gmail.com> 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 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 > ################################################################### > >
