pgBackRest for multiple production servers

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgBackRest for multiple production servers
Date: 2024-07-22 04:44:29
Message-ID: CAKgGyB-jw71v=EhM+BHX8Yvv=wk88mZoSYK7hdcD9iPH2cx70g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message sivapostgres@yahoo.com 2024-07-22 04:46:13 Re: Re. Select with where condition times out
Previous Message Thomas Munro 2024-07-22 01:13:10 Re: Windows installation problem at post-install step