pgBackRest for multiple production servers
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
###################################################################
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
KrishanePlease 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-cbcrepo1-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
process-max=5
log-level-console=info
log-level-file=debug
start-fast=y
delta=y
repo1-block=y
repo1-bundle=yrepo2-path=/var/lib/ Server_2_Backup
repo2-retention-full=2
repo2-cipher-type=aes-256-cbcrepo2-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-cbcrepoN-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
###################################################################