public inbox for [email protected]  
help / color / mirror / Atom feed
Backup Issue for pg_basebackup
3+ messages / 3 participants
[nested] [flat]

* Backup Issue for pg_basebackup
@ 2025-01-31 05:12  Somnath Som <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Somnath Som @ 2025-01-31 05:12 UTC (permalink / raw)
  To: [email protected]; Pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Backup Issue for pg_basebackup
@ 2025-02-01 21:21  SOzcn <[email protected]>
  parent: Somnath Som <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: SOzcn @ 2025-02-01 21:21 UTC (permalink / raw)
  To: Somnath Som <[email protected]>; +Cc: [email protected]; Pgsql-admin <[email protected]>

Hello,

This is a specific error. You need to specify the IP information of the
server where you are providing the replica and the user that will perform
the replication in pg_hba.conf on the main cluster. You can find examples
of this in many sources.

Have a nice day.

Somnath Som <[email protected]>, 1 Şub 2025 Cmt, 19:26 tarihinde şunu
yazdı:

> 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
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Backup Issue for pg_basebackup
@ 2025-02-02 08:14  Laurenz Albe <[email protected]>
  parent: Somnath Som <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Laurenz Albe @ 2025-02-02 08:14 UTC (permalink / raw)
  To: Somnath Som <[email protected]>; [email protected]; Pgsql-admin <[email protected]>

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2025-02-02 08:14 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-31 05:12 Backup Issue for pg_basebackup Somnath Som <[email protected]>
2025-02-01 21:21 ` SOzcn <[email protected]>
2025-02-02 08:14 ` Laurenz Albe <[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