Re: pgBackRest for multiple production servers

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

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

###################################################################