From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Somnath Som <somnath.spice@gmail.com>
To: pgadmin-support@lists.postgresql.org, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Backup Issue for pg_basebackup
Date: Sun, 02 Feb 2025 09:14:11 +0100
Message-ID: <a6f0355a4a2db098b93c1e7d1cf8da648ab51793.camel@cybertec.at> (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 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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, somnath.spice@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Backup Issue for pg_basebackup
In-Reply-To: <a6f0355a4a2db098b93c1e7d1cf8da648ab51793.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox