Date: Mon, 23 Mar 2020 18:30:36 +0000 (UTC)
From: Douglas Reed <dougreed765@yahoo.com>
Reply-To: Douglas Reed <dougreed765@yahoo.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Cc: Matthew Couper <mcouper@fsbtech.com>, Andrew Jobson <andrew@fsbtech.com>
Message-ID: <36847976.780175.1584988236276@mail.yahoo.com>
Subject: Problem with replication
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_780174_823238585.1584988236274"
References: <36847976.780175.1584988236276.ref@mail.yahoo.com>
Content-Length: 6246
Precedence: bulk

------=_Part_780174_823238585.1584988236274
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi
We are running Pg Version 9.6
On OS Centos 7 running on a VM (Nutanix)
We are trying to build a slave server on this platform. The relevant IP ent=
ry for replication has been placed in pg_hba.conf on the master. We run pg_=
basebackup successfully and then set up recovery.conf etc and re-start=C2=
=A0the slave database. It seems to process the WALs and then enter the read=
 only state when it then generates the following errors;
Mar 23 15:22:48 xds-data1-temp postgres[13072]: [2-1] user=3D,db=3D,app=3Dc=
lient=3D LOG:=C2=A0 database system is ready to accept read only connection=
sMar 23 15:22:49 xds-data1-temp postgres[13083]: [3-1] user=3D[unknown],db=
=3D[unknown],app=3D[unknown]client=3D[local] LOG:=C2=A0 connection received=
: host=3D[local]Mar 23 15:22:49 xds-data1-temp postgres[13083]: [4-1] user=
=3Dpostgres,db=3D[unknown],app=3D[unknown]client=3D[local] FATAL:=C2=A0 no =
pg_hba.conf entry for replication connection from host "[local]", user "pos=
tgres", SSL offMar 23 15:22:49 xds-data1-temp postgres[13082]: [3-1] user=
=3D,db=3D,app=3Dclient=3D FATAL:=C2=A0 could not connect to the primary ser=
ver: FATAL:=C2=A0 no pg_hba.conf entry for replication connection from host=
 "[local]", user "postgres", SSL offMar 23 15:22:49 xds-data1-temp postgres=
[13082]: [3-2]Mar 23 15:22:49 xds-data1-temp postgres[13085]: [3-1] user=3D=
[unknown],db=3D[unknown],app=3D[unknown]client=3D[local] LOG:=C2=A0 connect=
ion received: host=3D[local]Mar 23 15:22:49 xds-data1-temp postgres[13085]:=
 [4-1] user=3Dpostgres,db=3D[unknown],app=3D[unknown]client=3D[local] FATAL=
:=C2=A0 no pg_hba.conf entry for replication connection from host "[local]"=
, user "postgres", SSL offMar 23 15:22:49 xds-data1-temp postgres[13084]: [=
3-1] user=3D,db=3D,app=3Dclient=3D FATAL:=C2=A0 could not connect to the pr=
imary server: FATAL:=C2=A0 no pg_hba.conf entry for replication connection =
from host "[local]", user "postgres", SSL off
We know that the entry is in the hba and have checked for typos, but one th=
ing that does stick out with one line on the message is;=C2=A0
=C2=A0 =C2=A0 FATAL:=C2=A0 no pg_hba.conf entry for replication connection =
from host "[local]"=C2=A0
Other messages I have seen in the past would normally have an IP address wh=
ere is says "[local]"
Any ideas as to where we might be going wrong?=C2=A0 =C2=A0=C2=A0

Many thanks


Doug Reed=C2=A0dougreed765@yahoo.com=C2=A007973-132664https://uk.linkedin.c=
om/pub/douglas-reed/33/326/2b
------=_Part_780174_823238585.1584988236274
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp82a671c2yahoo-style-wrap" style=
=3D"font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 1=
3px;"><div><div dir=3D"ltr" data-setdir=3D"false"><div><div dir=3D"ltr" dat=
a-setdir=3D"false">Hi</div><div><br></div><div dir=3D"ltr" data-setdir=3D"f=
alse">We are running Pg Version 9.6</div><div><br></div><div dir=3D"ltr" da=
ta-setdir=3D"false">On OS Centos 7 running on a VM (Nutanix)</div><div><br>=
</div><div>We are trying to build a slave server on this platform. The rele=
vant IP entry for replication has been placed in pg_hba.conf on the master.=
 We run pg_basebackup successfully and then set up recovery.conf etc and re=
-start&nbsp;</div><div>the slave database. It seems to process the WALs and=
 then enter the read only state when it then generates the following errors=
;</div><div><br></div><div>Mar 23 15:22:48 xds-data1-temp postgres[13072]: =
[2-1] user=3D,db=3D,app=3Dclient=3D LOG:&nbsp; database system is ready to =
accept read only connections</div><div>Mar 23 15:22:49 xds-data1-temp postg=
res[13083]: [3-1] user=3D[unknown],db=3D[unknown],app=3D[unknown]client=3D[=
local] LOG:&nbsp; connection received: host=3D[local]</div><div>Mar 23 15:2=
2:49 xds-data1-temp postgres[13083]: [4-1] user=3Dpostgres,db=3D[unknown],a=
pp=3D[unknown]client=3D[local] FATAL:&nbsp; no pg_hba.conf entry for replic=
ation connection from host "[local]", user "postgres", SSL off</div><div>Ma=
r 23 15:22:49 xds-data1-temp postgres[13082]: [3-1] user=3D,db=3D,app=3Dcli=
ent=3D FATAL:&nbsp; could not connect to the primary server: FATAL:&nbsp; n=
o pg_hba.conf entry for replication connection from host "[local]", user "p=
ostgres", SSL off</div><div>Mar 23 15:22:49 xds-data1-temp postgres[13082]:=
 [3-2]</div><div>Mar 23 15:22:49 xds-data1-temp postgres[13085]: [3-1] user=
=3D[unknown],db=3D[unknown],app=3D[unknown]client=3D[local] LOG:&nbsp; conn=
ection received: host=3D[local]</div><div>Mar 23 15:22:49 xds-data1-temp po=
stgres[13085]: [4-1] user=3Dpostgres,db=3D[unknown],app=3D[unknown]client=
=3D[local] FATAL:&nbsp; no pg_hba.conf entry for replication connection fro=
m host "[local]", user "postgres", SSL off</div><div>Mar 23 15:22:49 xds-da=
ta1-temp postgres[13084]: [3-1] user=3D,db=3D,app=3Dclient=3D FATAL:&nbsp; =
could not connect to the primary server: FATAL:&nbsp; no pg_hba.conf entry =
for replication connection from host "[local]", user "postgres", SSL off</d=
iv><div><br></div><div>We know that the entry is in the hba and have checke=
d for typos, but one thing that does stick out with one line on the message=
 is;&nbsp;</div><div><br></div><div>&nbsp; &nbsp; FATAL:&nbsp; no pg_hba.co=
nf entry for replication connection from host "[local]"&nbsp;</div><div><br=
></div><div>Other messages I have seen in the past would normally have an I=
P address where is says "[local]"</div><div><br></div><div>Any ideas as to =
where we might be going wrong?&nbsp; &nbsp;&nbsp;</div><div><br></div><div>=
<br></div><div>Many thanks</div><div><br></div></div><br></div><div><br></d=
iv><div><br></div><div><br></div><div class=3D"ydp82a671c2signature">Doug R=
eed&nbsp;<div>dougreed765@yahoo.com&nbsp;</div><div>07973-132664</div><div>=
<span style=3D"color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-siz=
e:11px;line-height:17px;background-color:rgb(246, 246, 246);">https://uk.li=
nkedin.com/pub/douglas-reed/33/326/2b</span></div></div></div></div></body>=
</html>
------=_Part_780174_823238585.1584988236274--