public inbox for [email protected]
help / color / mirror / Atom feedRe: PgbackRest : Stanza creation fails on DB Server and Repo Server
3+ messages / 3 participants
[nested] [flat]
* Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
@ 2024-08-28 14:54 Amitabh Kant <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Amitabh Kant @ 2024-08-28 14:54 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: KK CHN <[email protected]>; pgsql-general
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.
Amitabh
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
@ 2024-08-28 14:58 David G. Johnston <[email protected]>
parent: Amitabh Kant <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2024-08-28 14:58 UTC (permalink / raw)
To: Amitabh Kant <[email protected]>; +Cc: KK CHN <[email protected]>; pgsql-general
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
@ 2024-08-29 04:57 KK CHN <[email protected]>
parent: David G. Johnston <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: KK CHN @ 2024-08-29 04:57 UTC (permalink / raw)
To: David G. Johnston <[email protected]>; +Cc: Amitabh Kant <[email protected]>; pgsql-general
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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-29 04:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-28 14:54 Re: PgbackRest : Stanza creation fails on DB Server and Repo Server Amitabh Kant <[email protected]>
2024-08-28 14:58 ` David G. Johnston <[email protected]>
2024-08-29 04:57 ` KK CHN <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox