public inbox for [email protected]  

help / color / mirror / Atom feed

From: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: PgbackRest stanza creation : on DB server or both DB and Repo server ?
Date: Thu, 29 Aug 2024 10:17:27 +0530
Message-ID: <CAKgGyB855wysqWZ8_X5buw=wvcepm+cx_p59-F1g38utFk9zPA@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PgbackRest stanza creation : on DB server or both DB and Repo server ?
  In-Reply-To: <CAKgGyB855wysqWZ8_X5buw=wvcepm+cx_p59-F1g38utFk9zPA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox