Re: no pg_hba.conf entry for replication connection from host

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(at)gmail(dot)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*
> volkanunsal.com <http://bit.ly/1h1ebjy>
>

--
*Volkan Unsal*
*web and mobile development*
volkanunsal.com <http://bit.ly/1h1ebjy>