MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Thu, 29 Aug 2024 10:17:27 +0530
Message-ID: <CAKgGyB855wysqWZ8_X5buw=wvcepm+cx_p59-F1g38utFk9zPA@mail.gmail.com>
Subject: PgbackRest stanza creation : on DB server or both DB and Repo server ?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006938d10620cb2ba4"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB855wysqWZ8_X5buw%3Dwvcepm%2Bcx_p59-F1g38utFk9zPA%40mail.gmail.com>
Precedence: bulk

--0000000000006938d10620cb2ba4
Content-Type: text/plain; charset="UTF-8"

List,

 I am configuring the   Pgbackrest  ( RHEL9.4 ,  EPAS 16  , PgbackRest
2.52.1 )  on two servers.(Database cluster server and   Repo Server).

Query.1  Do I need to create stanza on both   servers   ( DB server EPAS16
User : enterprisedb,    as well as on  RepoServer   user: postgres   )

1.  only creating stanza  either at  DB Server  but not on  RepoServer is
sufficient?  OR  I have to create the  stanza on both servers as follows ?

on DB server   ( RHEL 9.4, EPAS 16  : DB user is : enterprisedb  )
]#sudo -u enterprisedb pgbackrest --stanza=Repo --log-level-console=info
stanza-create

Initially It complains about another  pgbackrest running  and aborted the
stanza-creation
 second attempt  : Without complaining about  anything  the stanza creaton
successful  :)   I couldn't understand why it complained about  another
pgbackrest running in the first place ?
( before running stanza creation on DB server,  I first tried the stanza
creation on  RepoServer as   ]# sudo -u postgres pgbackrest --stanza=Repo
--log-level-console=info stanza-create


On Repo server : ( postgres user for Repo server, but no PG installed only
user  postgres is created for  backup purpose)

]# #sudo -u postgres pgbackrest --stanza=Repo --log-level-console=info
stanza-create

But no success(on multiple stanza creation attempts)   :  It always aborted
with a message  another pgbackrest is running ..


So  Only   stanza creation has to  performed  either  on  DB Server or
RepoServe but not on both servers ?

Kindly shed some light on this.

Thank you,
Krishane

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

<div dir=3D"ltr">List,=C2=A0<div><br></div><div>=C2=A0I am configuring the=
=C2=A0 =C2=A0Pgbackrest=C2=A0 ( RHEL9.4=C2=A0,=C2=A0 EPAS 16=C2=A0 , Pgback=
Rest 2.52.1 )=C2=A0 on two servers.(Database cluster server and=C2=A0 =C2=
=A0Repo Server).</div><div><br></div><div><span style=3D"background-color:r=
gb(255,153,0)">Query.1</span>=C2=A0 Do I need to create stanza on both=C2=
=A0 =C2=A0servers=C2=A0 =C2=A0( DB server EPAS16 User : enterprisedb,=C2=A0=
 =C2=A0 as well as on=C2=A0 RepoServer=C2=A0 =C2=A0user: postgres=C2=A0 =C2=
=A0)</div><div><br></div><div>1.=C2=A0 only creating stanza=C2=A0 either at=
=C2=A0 DB Server=C2=A0 but not on=C2=A0 RepoServer is sufficient?=C2=A0 OR=
=C2=A0 I have to create the=C2=A0 stanza on both servers as follows ?</div>=
<div><br></div><div>on DB server=C2=A0 =C2=A0( RHEL 9.4, EPAS 16=C2=A0 : DB=
 user is : <span style=3D"background-color:rgb(255,153,0)">enterprisedb</sp=
an>=C2=A0 )</div><div>]#sudo -u <span style=3D"background-color:rgb(255,153=
,0)">enterprisedb</span> pgbackrest --stanza=3DRepo --log-level-console=3Di=
nfo stanza-create=C2=A0<br></div><div><br></div><div>Initially It complains=
 about another=C2=A0 pgbackrest running=C2=A0 and aborted the stanza-creati=
on</div><div>=C2=A0second attempt=C2=A0 : Without complaining=C2=A0about=C2=
=A0 anything=C2=A0 the stanza creaton successful=C2=A0 :)=C2=A0 =C2=A0I cou=
ldn&#39;t understand why it complained about=C2=A0 another pgbackrest runni=
ng in the first place ?</div><div>( before running stanza creation on DB se=
rver,=C2=A0 I first tried the stanza creation on=C2=A0 RepoServer as=C2=A0 =
=C2=A0]# sudo -u postgres pgbackrest --stanza=3DRepo --log-level-console=3D=
info stanza-create </div><div><br></div><div><br></div><div><br></div><div>=
On Repo server : ( <span style=3D"background-color:rgb(255,153,0)">postgres=
</span> user for Repo server, but no PG installed only user=C2=A0 postgres =
is created for=C2=A0 backup purpose)</div><div><br></div><div>]# #sudo -u <=
span style=3D"background-color:rgb(255,153,0)">postgres</span> pgbackrest -=
-stanza=3DRepo --log-level-console=3Dinfo stanza-create=C2=A0<br></div><div=
><br></div><div>But no success(on multiple stanza creation attempts)=C2=A0 =
=C2=A0:=C2=A0 It always aborted with a message=C2=A0 another pgbackrest is =
running ..</div><div><br></div><div><br></div><div>So=C2=A0 Only=C2=A0 =C2=
=A0stanza creation has to=C2=A0 performed=C2=A0 either=C2=A0 on=C2=A0 DB Se=
rver or RepoServe but not on both servers ?</div><div><br></div><div>Kindly=
=C2=A0shed some light on this.=C2=A0</div><div><br></div><div>Thank you,</d=
iv><div>Krishane</div><div><br></div><div><br></div><div><br></div><div><br=
></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br=
></div></div>

--0000000000006938d10620cb2ba4--