PgbackRest stanza creation : on DB server or both DB and Repo server ?
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