On Wednesday, August 28, 2024, Amitabh Kant <amitabhk...@gmail.com> 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 <kkchn...@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.
