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@xxxxxxxxx> 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
