Re: no pg_hba.conf entry for replication connection from host - Mailing list pgsql-general

From Volkan Unsal
Subject Re: no pg_hba.conf entry for replication connection from host
Date
Msg-id CAMcqKmnO3BgLFCQCjW4TxstBd9R+Mj1goAaTHkjPMZWR3QbjaQ@mail.gmail.com
Whole thread Raw
In response to Re: no pg_hba.conf entry for replication connection from host  (Volkan Unsal <spocksplanet@gmail.com>)
Responses Re: no pg_hba.conf entry for replication connection from host
List pgsql-general
I set up logging for connections. Here is what I see:

LOG:  connection received: host=104.131.66.183 port=38912
LOG:  replication connection authorized: user=postgres
LOG:  connection received: host=104.131.66.183 port=38913
LOG:  replication connection authorized: user=postgres

Two connection attempts are made. First is probably for pg_basebackup. The second might be for streaming replication. If it's true, then I don't understand why it is not succeeding...


On Thu, Apr 9, 2015 at 5:22 PM, Volkan Unsal <spocksplanet@gmail.com> wrote:

Not sure that is a problem as the logs show the database reaching a consistent state:

But the database doesn't open a port after reaching this state. Hence, when I nmap the IP address of the standby server, I don't see an open port for postgresql. Is that normal?

Also setting up logging connects/disconnects on the primary to see if an attempt is even being made.

How would I set this up? I think I'm already seeing failed connection attempts since they raise FATAL errors, but maybe I'm not seeing successful connection attempts. 



--
Volkan Unsal
web and mobile development



--
Volkan Unsal
web and mobile development

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host
Next
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host