pgBackRest for multiple production servers

Started by KK CHNover 1 year ago2 messagesgeneral
Jump to latest
#1KK CHN
kkchn.in@gmail.com

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

#2Kashif Zeeshan
kashi.zeeshan@gmail.com
In reply to: KK CHN (#1)
Re: pgBackRest for multiple production servers

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

Show quoted text

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