Re: PgbackRest : Stanza creation fails on DB Server and Repo Server

2024-08-28 Thread KK CHN
Thank you all for the great help .. I couldn't get a chance toRestart the DB Cluster after making the changes highlighted. Correct me if I am wrong ( production server, down time requested. ) after editing the pg_hba.conf on DB server as follows local all all

Re: PgbackRest : Stanza creation fails on DB Server and Repo Server

2024-08-28 Thread David G. Johnston
On Wednesday, August 28, 2024, Amitabh Kant wrote: > On Wed, Aug 28, 2024 at 8:00 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wednesday, August 28, 2024, KK CHN wrote: >> >>> >>> and I have .pgpass in DB server as >>> >> >> You assumed this mattered but I see no mention

Re: PgbackRest : Stanza creation fails on DB Server and Repo Server

2024-08-28 Thread Amitabh Kant
On Wed, Aug 28, 2024 at 8:00 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, August 28, 2024, KK CHN wrote: > >> >> and I have .pgpass in DB server as >> > > You assumed this mattered but I see no mention that pgBackRest consults > this file. > > It seems to require th

Re: PgbackRest : Stanza creation fails on DB Server and Repo Server

2024-08-28 Thread David G. Johnston
On Wednesday, August 28, 2024, KK CHN wrote: > > and I have .pgpass in DB server as > You assumed this mattered but I see no mention that pgBackRest consults this file. It seems to require the local entry in pg_hba.conf to use peer authentication. David J.