Postgres Pro
Downloads
Home   >   mailing lists

Re: PgbackRest : Stanza creation fails on DB Server and Repo Server - Mailing list pgsql-general

From David G. Johnston
Subject Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
Date
Msg-id CAKFQuwax7xHofBW+phfbPDweGoqvf1BWbVwSVDKJTemR249LOg@mail.gmail.com
Whole thread Raw
In response to Re: PgbackRest : Stanza creation fails on DB Server and Repo Server  (Amitabh Kant <amitabhkant@gmail.com>)
Responses Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
List pgsql-general
Tree view
On Wednesday, August 28, 2024, Amitabh Kant <amitabhkant@gmail.com> wrote:
On Wed, Aug 28, 2024 at 8:00 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, August 28, 2024, KK CHN <kkchn.in@gmail.com> 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.


Section 21.4 on this page ( https://pgbackrest.org/user-guide.html#introduction )  does seem to mention the use of .pgpass file. I have no idea about the actual problem though.

Yes, postgres itself uses .pgpass so when you configure streaming replication between two servers, something that is doable regardless of using pgBackRest, the server-to-server connection can utilize .pgpass.

David J. 

pgsql-general by date:

Previous
From: Amitabh Kant
Date:
Subject: Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
Next
From: Jacob Biesinger
Date:
Subject: Re: Ghost data from failed FDW transactions?