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