Re: pgBackRest for multiple production servers

Hi

On Mon, Jul 22, 2024 at 9:35 AM KK CHN <kkchn(dot)in(at)gmail(dot)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
> ###################################################################
>
>