MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Wed, 28 Aug 2024 11:09:51 +0530
Message-ID: <CAKgGyB9jNiGJZHjQRhCico=6zGoxz8zWPrsv2xv5vm2c5tJvow@mail.gmail.com>
Subject: Pgbackrest specifying the default DB necessary/correct way ?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fa07e80620b7c896"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB9jNiGJZHjQRhCico%3D6zGoxz8zWPrsv2xv5vm2c5tJvow%40mail.gmail.com>
Precedence: bulk

--000000000000fa07e80620b7c896
Content-Type: text/plain; charset="UTF-8"

List,

I have configured the pgbackrest on a live DB server  and  a Repo Server. (
EPAS 16, RHEL 9.4 and Pgbackrest 2.52.1 )

On DB Server I have
##############################
[root@db1 ~]# cd
[root@db1 ~]# cat /etc/pgbackrest/pgbackrest.conf
[Demo_Repo]
pg1-path=/data/edb/as16/data
pg1-port=5444
pg1-user=enterprisedb
pg-version-force=16
pg1-database=edb                *##   Query 1. *

[global]
repo1-host=10.255.0.40
repo1-host-user=postgres
archive-async=y
spool-path=/var/spool/pgbackrest
log-level-console=info
log-level-file=debug
delta=y

[global:archive-get]
process-max=2

[global:archive-push]
process-max=4
##############################################

*## Query 1:  *

  In this DB server    I have other databases  than the default  "edb"
database.     Specifying the above line as    pg1-database=edb   // I am
not sure this line is necessary  or not ?

( I am just learning and exploring PgbackRest)  found online some reference
configurations so using like this )

 pg1-database=edb // specifying like this, will it block other databases
on this server to get backed up ?   IF yes how can I overcome this ?

I want all databases on this server to be backed up to the remote
repository.


It is a production server and I can't perform a trial and error method here
to understand how it works.


Please shed some light on this .


Thanks ,
Krishane

--000000000000fa07e80620b7c896
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">List,=C2=A0=C2=A0<div><br></div><div>I have configured the=
 pgbackrest on a live DB server=C2=A0 and=C2=A0 a Repo Server. ( EPAS 16, R=
HEL 9.4 and Pgbackrest 2.52.1 )</div><div><br></div><div>On DB Server I hav=
e</div><div>##############################<br>[root@db1 ~]# cd<br>[root@db1=
 ~]# cat /etc/pgbackrest/pgbackrest.conf<br>[Demo_Repo]<br>pg1-path=3D/data=
/edb/as16/data<br>pg1-port=3D5444<br>pg1-user=3Denterprisedb<br>pg-version-=
force=3D16<br>pg1-database=3Dedb=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 <b style=3D"background-color:rgb(255,153,0)">##=C2=A0 =C2=A0Q=
uery 1.=C2=A0</b><br><br>[global]<br>repo1-host=3D10.255.0.40<br>repo1-host=
-user=3Dpostgres<br>archive-async=3Dy<br>spool-path=3D/var/spool/pgbackrest=
<br>log-level-console=3Dinfo<br>log-level-file=3Ddebug<br>delta=3Dy<br><br>=
[global:archive-get]<br>process-max=3D2<br><br>[global:archive-push]<br>pro=
cess-max=3D4<br></div><div>##############################################</=
div><div><span style=3D"background-color:rgb(255,153,0)"><br></span></div><=
div><b style=3D"background-color:rgb(255,153,0)">## Query 1:=C2=A0=C2=A0</b=
></div><div><br></div><div>=C2=A0 In this DB server=C2=A0 =C2=A0 I have oth=
er databases=C2=A0 than the default=C2=A0 &quot;edb&quot; database.=C2=A0 =
=C2=A0 =C2=A0Specifying the above line as=C2=A0 =C2=A0 pg1-database=3Dedb=
=C2=A0 =C2=A0// I am not sure this line is necessary=C2=A0 or not ?</div><d=
iv><br></div><div>( I am just learning and exploring PgbackRest)=C2=A0 foun=
d online some reference configurations so using like this )<br></div><div><=
br></div><div>=C2=A0pg1-database=3Dedb // specifying like this, will it blo=
ck other databases=C2=A0 on this server to get backed up ?=C2=A0 =C2=A0IF y=
es how can I overcome this ?</div><div><br></div><div>I want all=C2=A0datab=
ases on this server to be backed up to the remote repository.=C2=A0</div><d=
iv><br></div><div><br></div><div>It is a production server and I can&#39;t =
perform a trial and error method here to=C2=A0understand how it works.=C2=
=A0</div><div><br></div><div><br></div><div>Please shed some light on this =
.</div><div><br></div><div><br></div><div>Thanks ,</div><div>Krishane</div>=
<div><br></div><div><br></div></div>

--000000000000fa07e80620b7c896--