MIME-Version: 1.0
References: 
 <CALD8Sm+-qb-xjMVXOXZGyK_VDAtMS2T9ecx_CmoDMok3Ra_FzQ@mail.gmail.com>
In-Reply-To: 
 <CALD8Sm+-qb-xjMVXOXZGyK_VDAtMS2T9ecx_CmoDMok3Ra_FzQ@mail.gmail.com>
From: SOzcn <selahattinozcnma@gmail.com>
Date: Sun, 2 Feb 2025 00:21:12 +0300
Message-ID: 
 <CAJyV5AYp4hRBuA8a2aQ_XTs5_6RgjsShD-Aty_o7Maixpo50-Q@mail.gmail.com>
Subject: Re: Backup Issue for pg_basebackup
To: Somnath Som <somnath.spice@gmail.com>
Cc: pgadmin-support@lists.postgresql.org,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d1fb1f062d1b3d44"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJyV5AYp4hRBuA8a2aQ_XTs5_6RgjsShD-Aty_o7Maixpo50-Q%40mail.gmail.com>
Precedence: bulk

--000000000000d1fb1f062d1b3d44
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 <somnath.spice@gmail.com>, 1 =C5=9Eub 2025 Cmt, 19:26 tarihinde=
 =C5=9Funu
yazd=C4=B1:

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

--000000000000d1fb1f062d1b3d44
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Hello,</p>
<p>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 t=
he replication in <code>pg_hba.conf</code> on the main cluster. You can fin=
d examples of this in many sources.</p>
<p>Have a nice day.</p></div><br><div class=3D"gmail_quote gmail_quote_cont=
ainer"><div dir=3D"ltr" class=3D"gmail_attr">Somnath Som &lt;<a href=3D"mai=
lto:somnath.spice@gmail.com">somnath.spice@gmail.com</a>&gt;, 1 =C5=9Eub 20=
25 Cmt, 19:26 tarihinde =C5=9Funu yazd=C4=B1:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div>We are getting below er=
ror when running pg_basebackup for a database.</div><div><br></div><div>


<p style=3D"margin:0cm;font-size:11pt;font-family:Calibri,sans-serif">pg_ba=
sebackup: error: FATAL:<span>=C2=A0 </span>no pg_hba.conf entry for replica=
tion
connection from host &quot;127.0.0.1&quot;, user &quot;postgres&quot;, SSL =
on<span></span></p>

<p style=3D"margin:0cm;font-size:11pt;font-family:Calibri,sans-serif">FATAL=
:<span>=C2=A0 </span>no
pg_hba.conf entry for replication connection from host &quot;127.0.0.1&quot=
;,
user &quot;postgres&quot;, SSL off -e<span></span></p></div><br></div>
</blockquote></div>

--000000000000d1fb1f062d1b3d44--