MIME-Version: 1.0
In-Reply-To: <CAPTAQBLb3iaPMwcf45xz9GtR1qkQiEYqYa_R-ukNADHbpZZGNQ@mail.gmail.com>
References: <CAKgGyB_go+bQbN94ShuKVeqzFfKfKOTswRooCtBYY+omC4MFUw@mail.gmail.com>
 <CAKFQuwbLQ0F2igoUFWq5k602fwRjTBCua4hD98Rv1HQXC49tGw@mail.gmail.com> <CAPTAQBLb3iaPMwcf45xz9GtR1qkQiEYqYa_R-ukNADHbpZZGNQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 28 Aug 2024 07:58:04 -0700
Message-ID: <CAKFQuwax7xHofBW+phfbPDweGoqvf1BWbVwSVDKJTemR249LOg@mail.gmail.com>
Subject: Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
To: Amitabh Kant <amitabhkant@gmail.com>
Cc: KK CHN <kkchn.in@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d807320620bf9502"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwax7xHofBW%2BphfbPDweGoqvf1BWbVwSVDKJTemR249LOg%40mail.gmail.com>
Precedence: bulk

--000000000000d807320620bf9502
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, August 28, 2024, Amitabh Kant <amitabhkant@gmail.com> wrote:

> On Wed, Aug 28, 2024 at 8:00=E2=80=AFPM 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.

--000000000000d807320620bf9502
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, August 28, 2024, Amitabh Kant &lt;<a href=3D"mailto:amitabhka=
nt@gmail.com">amitabhkant@gmail.com</a>&gt; wrote:<br><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"ltr"><div>On Wed, Aug 28, 2024 at 8:00=E2=80=AFPM Dav=
id G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=3D"=
_blank">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><div class=3D"gm=
ail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Wednesday, =
August 28, 2024, KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com" target=3D=
"_blank">kkchn.in@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"ltr"><div><br></div><div>and I have=C2=A0 =
=C2=A0.pgpass in DB server as=C2=A0</div></div></blockquote><div><br></div>=
<div>You assumed this mattered but I see no mention that pgBackRest consult=
s this file.</div><div><br></div><div>It seems to require the local entry i=
n pg_hba.conf to use peer authentication.</div><div><br></div><div>David J.=
</div><div><br></div></blockquote><div><br></div><div>Section 21.4 on this =
page ( <a href=3D"https://pgbackrest.org/user-guide.html#introduction" targ=
et=3D"_blank">https://pgbackrest.org/user-<wbr>guide.html#introduction</a> =
)=C2=A0 does seem to mention the=C2=A0use of .pgpass file. I have no idea a=
bout the actual problem though.</div></div></div></blockquote><div><br></di=
v><div>Yes, postgres itself uses .pgpass so when you configure streaming re=
plication between two servers, something that is doable regardless of using=
 pgBackRest, the server-to-server connection can utilize .pgpass.</div><div=
><br></div><div>David J.=C2=A0</div>

--000000000000d807320620bf9502--