From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Problem with replication
Date: Mon, 23 Mar 2020 19:33:45 +0100
Message-ID: <c7ff32b3-8545-bd7c-1865-3e6dcf9057c8@jakobs.com> (raw)
In-Reply-To: <36847976.780175.1584988236276@mail.yahoo.com>
References: <36847976.780175.1584988236276.ref@mail.yahoo.com>
<36847976.780175.1584988236276@mail.yahoo.com>
Hi Douglas,
the connection attempt has obviously been started via a "local"
connection, using a Unix socket instead of TCP/IP. Therefore, no IP
address is involved.
Is the slave db on the same machine?
Regards,
Holger
Am 23.03.20 um 19:30 schrieb Douglas Reed:
> 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 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
> the 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=,db=,app=client= LOG: database system is ready to accept read
> only connections
> Mar 23 15:22:49 xds-data1-temp postgres[13083]: [3-1]
> user=[unknown],db=[unknown],app=[unknown]client=[local] LOG:
> connection received: host=[local]
> Mar 23 15:22:49 xds-data1-temp postgres[13083]: [4-1]
> user=postgres,db=[unknown],app=[unknown]client=[local] FATAL: no
> pg_hba.conf entry for replication connection from host "[local]", user
> "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-1]
> user=,db=,app=client= FATAL: could not connect to the primary server:
> FATAL: no pg_hba.conf entry for replication connection from host
> "[local]", user "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-2]
> Mar 23 15:22:49 xds-data1-temp postgres[13085]: [3-1]
> user=[unknown],db=[unknown],app=[unknown]client=[local] LOG:
> connection received: host=[local]
> Mar 23 15:22:49 xds-data1-temp postgres[13085]: [4-1]
> user=postgres,db=[unknown],app=[unknown]client=[local] FATAL: no
> pg_hba.conf entry for replication connection from host "[local]", user
> "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13084]: [3-1]
> user=,db=,app=client= FATAL: could not connect to the primary server:
> FATAL: 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 thing that does stick out with one line on the message is;
>
> FATAL: no pg_hba.conf entry for replication connection from host
> "[local]"
>
> Other messages I have seen in the past would normally have an IP
> address where is says "[local]"
>
> Any ideas as to where we might be going wrong?
>
>
> Many thanks
>
>
>
>
>
> Doug Reed
> dougreed765@yahoo.com
> 07973-132664
> https://uk.linkedin.com/pub/douglas-reed/33/326/2b
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Problem with replication
In-Reply-To: <c7ff32b3-8545-bd7c-1865-3e6dcf9057c8@jakobs.com>
* 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