public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Somnath Som <[email protected]>
To: [email protected]
To: Pgsql-admin <[email protected]>
Subject: Re: Backup Issue for pg_basebackup
Date: Sun, 02 Feb 2025 09:14:11 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CALD8Sm+-qb-xjMVXOXZGyK_VDAtMS2T9ecx_CmoDMok3Ra_FzQ@mail.gmail.com>
References: <CALD8Sm+-qb-xjMVXOXZGyK_VDAtMS2T9ecx_CmoDMok3Ra_FzQ@mail.gmail.com>

On Fri, 2025-01-31 at 10:42 +0530, Somnath Som wrote:
> We are getting below error when running pg_basebackup for a database.
> 
> pg_basebackup: error: FATAL:  no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL on
> FATAL:  no pg_hba.conf entry for replication connection from host "127.0.0.1", user "postgres", SSL off -e

Add an entry like

  host  replication  postgres  127.0.0.1/32  trust

Reload PostgreSQL, and you should be fine.

Yours,
Laurenz Albe

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], [email protected]
  Subject: Re: Backup Issue for pg_basebackup
  In-Reply-To: <[email protected]>

* 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