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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
Дата
Msg-id CAKFQuwax7xHofBW+phfbPDweGoqvf1BWbVwSVDKJTemR249LOg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PgbackRest : Stanza creation fails on DB Server and Repo Server  (Amitabh Kant <amitabhkant@gmail.com>)
Ответы Re: PgbackRest : Stanza creation fails on DB Server and Repo Server
Список 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. 

В списке pgsql-general по дате отправления: