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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, August 28, 2024, Amitabh Kant <amitabhkant@xxxxxxxxx> wrote:

On Wed, Aug 28, 2024 at 8:00 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wednesday, August 28, 2024, KK CHN <kkchn.in@xxxxxxxxx> 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.