MIME-Version: 1.0
References: <CAKgGyB9jNiGJZHjQRhCico=6zGoxz8zWPrsv2xv5vm2c5tJvow@mail.gmail.com>
 <CAKAnmmK8Xnuxwsq4OUUZ7af=DqktRKWoWZ+2n8Upf5f_rQyGfg@mail.gmail.com>
In-Reply-To: <CAKAnmmK8Xnuxwsq4OUUZ7af=DqktRKWoWZ+2n8Upf5f_rQyGfg@mail.gmail.com>
From: KK CHN <kkchn.in@gmail.com>
Date: Wed, 28 Aug 2024 19:12:42 +0530
Message-ID: <CAKgGyB_pSPeUHjtjp+HjeiPS63HeULv_SUXq9C2Gou4fVZKaig@mail.gmail.com>
Subject: Re: Pgbackrest specifying the default DB necessary/correct way ?
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c715670620be87cf"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB_pSPeUHjtjp%2BHjeiPS63HeULv_SUXq9C2Gou4fVZKaig%40mail.gmail.com>
Precedence: bulk

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

Very helpful.

On Wed, Aug 28, 2024 at 5:51=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Wed, Aug 28, 2024 at 1:39=E2=80=AFAM KK CHN <kkchn.in@gmail.com> wrote=
:
>
>> In this DB server    I have other databases  than the default  "edb"
>> database.     Specifying the above line as    pg1-database=3Dedb   // I =
am
>> not sure this line is necessary  or not ?
>>
>
> The pgbackrest process needs to connect to the database, which means it
> needs a user and database. You need this variable if you do not have the
> default database, "postgres". If you have a database named postgres, you
> can leave this out. Otherwise, yes, it is necessary.
>
>  pg1-database=3Dedb // specifying like this, will it block other database=
s
>> on this server to get backed up ?   IF yes how can I overcome this ?
>>
>
> pgBackRest works on a cluster level, so *all* the databases are backed up=
.
> Indeed, it is not possible to only backup some of the databases. It's the
> whole cluster.
>
>  ( I am just learning and exploring PgbackRest)  found online some
>> reference configurations so using like this )
>
>
> Probably best to stick to the official docs; this section in particular i=
s
> worth a read:
>
> https://pgbackrest.org/user-guide-rhel.html
>
> Cheers,
> Greg
>
>
>

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

<div dir=3D"ltr">Very helpful.=C2=A0<br></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Aug 28, 2024 at 5:51=E2=80=
=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfid=
s@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, Aug 28, 2024 at 1:39=
=E2=80=AFAM KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com" target=3D"_bla=
nk">kkchn.in@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>In t=
his DB server=C2=A0 =C2=A0 I have other 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 i=
s necessary=C2=A0 or not ?<br></div></div></blockquote><div><br></div><div>=
The pgbackrest process needs to connect to the database, which means it nee=
ds a user and database. You need this variable if you do not have the defau=
lt database, &quot;postgres&quot;. If you have a database named postgres, y=
ou can leave this out. Otherwise, yes, it is necessary.</div><div><br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>=
=C2=A0pg1-database=3Dedb // specifying like this, will it block other datab=
ases=C2=A0 on this server to get backed up ?=C2=A0 =C2=A0IF yes how can I o=
vercome this ?</div></div></blockquote><div><br></div><div>pgBackRest works=
 on a cluster level, so *all* the databases are backed up. Indeed, it is no=
t possible to only backup some of the databases. It&#39;s the whole cluster=
.</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=C2=
=A0( I am just learning and exploring PgbackRest)=C2=A0 found online some r=
eference configurations so using like this )</blockquote><div><br></div><di=
v>Probably best to stick to the official docs; this section in particular i=
s worth a read:</div><div><br></div><div><a href=3D"https://pgbackrest.org/=
user-guide-rhel.html" target=3D"_blank">https://pgbackrest.org/user-guide-r=
hel.html</a><br></div><div><br></div><div>Cheers,</div><div>Greg</div><div>=
<br></div><div><br></div></div></div>
</blockquote></div>

--000000000000c715670620be87cf--