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
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
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
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.
I am trying pgbackrest config on a Production Server and a Repo server (
RHEL 9.4 EPAS 16 , pgbackrest 2.52.1
I have configured pbbackrest.conf on both machines as per the official
docs.
>From b*oth machines password less auth works for the db user *(enterprisedb
) and repouser(postgres)
.
