public inbox for [email protected]
help / color / mirror / Atom feedFrom: KK CHN <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Amitabh Kant <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
Date: Thu, 29 Aug 2024 10:27:39 +0530
Message-ID: <CAKgGyB__3EiBpJeUk5GxowOUOqouViQT3CY229EEZ85sfJFb5A@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwax7xHofBW+phfbPDweGoqvf1BWbVwSVDKJTemR249LOg@mail.gmail.com>
References: <CAKgGyB_go+bQbN94ShuKVeqzFfKfKOTswRooCtBYY+omC4MFUw@mail.gmail.com>
<CAKFQuwbLQ0F2igoUFWq5k602fwRjTBCua4hD98Rv1HQXC49tGw@mail.gmail.com>
<CAPTAQBLb3iaPMwcf45xz9GtR1qkQiEYqYa_R-ukNADHbpZZGNQ@mail.gmail.com>
<CAKFQuwax7xHofBW+phfbPDweGoqvf1BWbVwSVDKJTemR249LOg@mail.gmail.com>
Thank you all for the great help ..
I couldn't get a chance to Restart 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 trust
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 10.0.0.0/8 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
#local replication all md5
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
host replication all 10.0.0.0/8 md5
[root@db1 edb]#
But a work around seems worked as follows :
[root@db1 edb]# cat .pgpass
*:*:replication:enterprisedb:my_password
changed to
[root@db1 edb]# cat .pgpass
*:*:*:enterprisedb:password
For those struggling with this issue this may help ...
on the DB server's enterprisedb user's home directory ( Here it is
/var/lib/edb/ )
[root@db1 edb]# cat .pgpass
*:*:*:enterprisedb:password
[root@db1 edb]# ls -al .pgpass
-rw-------. 1 enterprisedb enterprisedb 28 Aug 29 09:26 .pgpass
[root@db1 edb]#
[root@db1 edb]# ls -al .pgpass
-rw-------. 1 enterprisedb enterprisedb 28 Aug 29 09:26 .pgpass
[root@db1 edb]#
On Wed, Aug 28, 2024 at 8:28 PM David G. Johnston <
[email protected]> wrote:
> On Wednesday, August 28, 2024, Amitabh Kant <[email protected]> wrote:
>
>> On Wed, Aug 28, 2024 at 8:00 PM David G. Johnston <
>> [email protected]> wrote:
>>
>>> On Wednesday, August 28, 2024, KK CHN <[email protected]> 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.
>
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
In-Reply-To: <CAKgGyB__3EiBpJeUk5GxowOUOqouViQT3CY229EEZ85sfJFb5A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox