From: | KK CHN <kkchn(dot)in(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | PgbackRest stanza creation : on DB server or both DB and Repo server ? |
Date: | 2024-08-29 04:47:27 |
Message-ID: | CAKgGyB855wysqWZ8_X5buw=wvcepm+cx_p59-F1g38utFk9zPA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | KK CHN | 2024-08-29 04:57:39 | Re: PgbackRest : Stanza creation fails on DB Server and Repo Server |
Previous Message | Michael Jaskiewicz | 2024-08-29 01:58:06 | Postgres Logical Replication - how to see what subscriber is doing with received data? |