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 <spockspla...@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* > volkanunsal.com <http://bit.ly/1h1ebjy> > -- *Volkan Unsal* *web and mobile development* volkanunsal.com <http://bit.ly/1h1ebjy>
