public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kashif Zeeshan <[email protected]>
To: KK CHN <[email protected]>
Cc: [email protected]
Subject: Re: pgBackRest for multiple production servers
Date: Fri, 26 Jul 2024 12:05:41 +0500
Message-ID: <CAAPsdhd=fFa-JAwVWE3E1U25_7+A9VMKR+ZAD5Z-OEQ9H70+3w@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB-jw71v=EhM+BHX8Yvv=wk88mZoSYK7hdcD9iPH2cx70g@mail.gmail.com>
References: <CAKgGyB-jw71v=EhM+BHX8Yvv=wk88mZoSYK7hdcD9iPH2cx70g@mail.gmail.com>
Hi
On Mon, Jul 22, 2024 at 9:35 AM KK CHN <[email protected]> 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
> ###################################################################
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pgBackRest for multiple production servers
In-Reply-To: <CAAPsdhd=fFa-JAwVWE3E1U25_7+A9VMKR+ZAD5Z-OEQ9H70+3w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox