Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sVklu-00BTSu-5a for pgsql-general@arkaria.postgresql.org; Mon, 22 Jul 2024 04:35:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sVklq-00Eh8g-9M for pgsql-general@arkaria.postgresql.org; Mon, 22 Jul 2024 04:35:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sVklp-00Eh7n-QE for pgsql-general@lists.postgresql.org; Mon, 22 Jul 2024 04:35:34 +0000 Received: from mail-yw1-x1134.google.com ([2607:f8b0:4864:20::1134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sVkln-000nX8-6E for pgsql-general@lists.postgresql.org; Mon, 22 Jul 2024 04:35:32 +0000 Received: by mail-yw1-x1134.google.com with SMTP id 00721157ae682-6510c0c8e29so36818097b3.0 for ; Sun, 21 Jul 2024 21:35:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721622930; x=1722227730; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=gzBWg9+gDlUWHAlt0cjl4NUH22O4wzPBtyT8DzUQI/o=; b=MxoXm2RqkjMKzbv9eIJZo+a1eydqfCcnQ/4J4Z7aucHk9JDEtPh785ZfUASyfWRYQy /N2GB7rp9hw22Ns2IIZoim3GicOUPl5qbNXK1AltSh0cO65ig2OrZMinrJPHZbycgzBf iu7mWhLoLTwxD7TA51mOAr0G1fMzUjaR0i48z7OVjTZGgXAKg51maeO8kr4Y1Lp+JE5V /x7cgJy37rrZ3GBXsHcdQQA1MwSrxiuqIhKgkgbdcsBbP72q4Dw6gzoJZ4RhFjCTrr3b lN/DPB3njwoeO7U+FquAOTUx6EHUdGI68hSiaJZx7RDXd/a45BnuSkrXFdBimcxDqB9+ S4Qw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721622930; x=1722227730; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=gzBWg9+gDlUWHAlt0cjl4NUH22O4wzPBtyT8DzUQI/o=; b=IE1l801yTDqdBMGpdsfjaSf+f4FP3JCIjvjbtN1LMC3/h35Dw/qrivdcH9gbF0Xh3S KjRn6FANXjXWDq3xgZIucaLL44Ti+60qEES7UY0ckvWnlmBxN/Wuk7P++8mgjYi7/Rmh KdJaq0kXro6nBtnKw5TZFHM740zPta4Uu7KJ16NKlaJGxEoE3bq0EBKv7VCuoAOAetgv 1Va1hjUIWYg2v6j7WIkHcDxSrn28arXQ18bzuTfwX+a9MVbrT7TVydMYZp8SUqXz0cQm 9mRvcuXfLQjue2oyjSFc+Em8jtcobTJWvR+lrRb9Wa3Koo2LbeiMLUdVKrWJ8wSRvd5f ke4g== X-Gm-Message-State: AOJu0Yzv3G8zAEsUGEWDEzgrZzs0vI9/xv/yqI9CPdGprjpg6gKNte23 4OfTSPF5ji5rliekT/Y2iusG71eu+LLZfduhbEc9nXP44D2P/KoJGHJZTZ4fyaepacNfwN+C1tL tDm0hwuUWWOppFUebZVTdmHclEgQ6x2IF X-Google-Smtp-Source: AGHT+IH4hi82d9N9vDrmspAiCx3MjILSFbCJNm9DiZYkJ7EFRyeY4PNGPweB8EyTu5NNuppaVrLd/p7s/2J1UrFkyOg= X-Received: by 2002:a05:690c:17:b0:668:a311:83c7 with SMTP id 00721157ae682-66ad8211b57mr88510767b3.1.1721622930228; Sun, 21 Jul 2024 21:35:30 -0700 (PDT) MIME-Version: 1.0 From: KK CHN Date: Mon, 22 Jul 2024 10:14:29 +0530 Message-ID: Subject: pgBackRest for multiple production servers To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000318e68061dce9357" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000318e68061dce9357 Content-Type: text/plain; charset="UTF-8" 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 ################################################################### --000000000000318e68061dce9357 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi list ,=C2=A0

I am exploring the=C2= =A0 PgBackRest tool for production deployment. ( My lab setup with one=C2= =A0 =C2=A0Database server and another Reposerver deployed working fine as i= n the official docs)
=C2=A0
Query:=C2=A0

=
What may be the standard practice employed to=C2=A0 backup multi= ple production servers to one RepoServer ? ( the pgbackrest configuration o= n the RepoServer part )

Is this the=C2=A0 right wa= y to achieve this (Defining multiple=C2=A0stanzas=C2=A0 Server1,=C2=A0 Server=C2=A0 2 ..=C2=A0 Server=C2=A0 N and single=C2=A0 [global] with=C2=A0 repo1, repo2 and repon = N=C2=A0 declarations=C2=A0 =C2=A0?

Please corr= ect me if I am wrong ..

Thank you=C2=A0
= Krishane


Please find the proposed= =C2=A0 =C2=A0pgbackrest.conf=C2=A0 =C2=A0in the=C2=A0 RepoServer=C2=A0 for = backing up multiple database servers.

/etc/pgbackr= est/pgbackrest.conf=C2=A0 =C2=A0on=C2=A0 RepoServer
#############= #####################################
[ Server=C2=A0 _1]
pg1-host=3D10.20.20.6
pg1-host-user=3D pgback= User
pg1-path=3D/var/lib/pgsql/16/data
. . . . .=C2=A0 . .= .=C2=A0 . . . . . . . . . . . . . . . . .=C2=A0=C2=A0
. . . . . = . .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .= =C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0=C2=A0
. . . . . . . . . .= =C2=A0 . . . . . .. .. . .. . . . .

[ Server=C2=A0 _N]
pgN-host=3D10.20.20.N
pgN-host-user=3D pgbackUser
pgN-path=3D/var/lib/pgsql/16/data


[global]
repo1-path=3D/var/lib/ Server_1_Backup
repo1-retention-full=3D2
repo1-cipher-type=3Daes-256-= cbc
repo1-cipher-pass=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQK= Cw6Sm99FnOfHBY
process-max=3D5
log-level-console=3Dinfo
log-level-= file=3Ddebug
start-fast=3Dy
delta=3Dy
repo1-block=3Dy
repo1-bun= dle=3Dy

repo2-path=3D/var/lib/ Server_2_Backup
repo2-retention-full=3D2
repo2-cipher-type=3Da= es-256-cbc
repo2-cipher-pass=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUH= o9R2VQKCw6Sm99FnOfHBY
process-max=3D5
log-level-console=3Dinfo
log= -level-file=3Ddebug
start-fast=3Dy
delta=3Dy
repo2-block=3Dy
re= po2-bundle=3Dy

.=C2=A0 =C2=A0.=C2=A0 =C2=A0.= =C2=A0 =C2=A0.=C2=A0 . .=C2=A0 .=C2=A0 .=C2=A0 =C2=A0.=C2=A0 .=C2=A0 .=C2= =A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 . .=C2=A0 .=C2= =A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 =C2=A0 =C2=A0=C2=A0
.= =C2=A0 =C2=A0.=C2=A0 =C2=A0.=C2=A0 =C2=A0.=C2=A0 . .=C2=A0 .=C2=A0 .=C2=A0 = =C2=A0.=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2= =A0 .=C2=A0 . .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0
.=C2=A0 =C2=A0.=C2=A0 =C2=A0.=C2=A0 =C2=A0.=C2=A0 . .=C2=A0 .=C2= =A0 .=C2=A0 =C2=A0.=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .= =C2=A0 .=C2=A0 .=C2=A0 . .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .=C2=A0 .= =C2=A0

repoN-path=3D/var/lib Server_N_Backup
repoN-retention-full=3D2
repoN-cipher-type=3Da= es-256-cbc
repoN-cipher-pass=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUH= o9R2VQKCw6Sm99FnOfHBY
process-max=3D5
log-level-console=3Dinfo
log= -level-file=3Ddebug
start-fast=3Dy
delta=3Dy
repoN-block=3Dy
re= poN-bundle=3Dy


[global:archiv= e-push]
compress-level=3D3
###############################= ####################################

--000000000000318e68061dce9357--