Re: Backup Issue for pg_basebackup

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Somnath Som <somnath(dot)spice(at)gmail(dot)com>, pgadmin-support(at)lists(dot)postgresql(dot)org, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Backup Issue for pg_basebackup
Date: 2025-02-02 08:14:11
Message-ID: a6f0355a4a2db098b93c1e7d1cf8da648ab51793.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Yogesh Mahajan 2025-02-04 04:17:41 Re: Unable to start pgAdmin on first install
Previous Message SOzcn 2025-02-01 21:21:12 Re: Backup Issue for pg_basebackup

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2025-02-02 12:52:21 Parameter Settings - Instance-Database-Specific
Previous Message Tim Gerber 2025-02-01 22:05:16 Re: Assistance with documenting a failover / fallback process that maintains replication