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

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

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 a=
m
> 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 databases
> 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 is
worth a read:

https://pgbackrest.org/user-guide-rhel.html

Cheers,
Greg

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Aug 28, 2024 at 1:39=E2=80=AFAM K=
K CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com">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-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"ltr"><div>In this DB server=C2=A0 =C2=A0 I ha=
ve 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 is necessary=C2=A0 or not ?<b=
r></div></div></blockquote><div><br></div><div>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, &quot;postgres&=
quot;. If you have a database named postgres, you can leave this out. Other=
wise, 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 // sp=
ecifying like this, will it block other databases=C2=A0 on this server to g=
et backed up ?=C2=A0 =C2=A0IF yes how can I overcome this ?</div></div></bl=
ockquote><div><br></div><div>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&#39;s the whole cluster.</div><div><br></div><blockqu=
ote 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 ex=
ploring PgbackRest)=C2=A0 found online some reference configurations so usi=
ng like this )</blockquote><div><br></div><div>Probably best to stick to th=
e official docs; this section in particular is worth a read:</div><div><br>=
</div><div><a href=3D"https://pgbackrest.org/user-guide-rhel.html">https://=
pgbackrest.org/user-guide-rhel.html</a><br></div><div><br></div><div>Cheers=
,</div><div>Greg</div><div><br></div><div><br></div></div></div>

--000000000000d87c630620bd647c--