Horton

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

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Amitabh Kant <amitabhkant@gmail.com>
Cc: KK CHN <kkchn.in@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2024-08-28T14:58:04Z
Lists: pgsql-general 
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.