Thread

1. pgBackRest for multiple production servers

   KK CHN <kkchn.in@gmail.com> — 2024-07-22T04:44:29Z

   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
   ###################################################################
   

2. Re: pgBackRest for multiple production servers

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-26T07:05:41Z

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