| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |