On 04/09/2015 10:15 AM, Volkan Unsal wrote:
I have been configuring a slave server that needs to connect to the host. Both the master and the standby servers have a pg_hba.conf that looks like this:# Allow anyone to connect remotely so long as they have a valid username and # password. host replication ${REP_USER} 0.0.0.0/0 <http://0.0.0.0/0> md5 host ${DB_NAME} ${DB_USER} 0.0.0.0/0 <http://0.0.0.0/0> md5 This should allow access from every IP address, right? Evidently, though, the standby server cannot connect using the REP_USER credentials via `primary_conninfo` primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432 user=${REP_USER} password=${REP_PASS}' I know this doesn't work because I never see in my logs: LOG: streaming replication successfully connected to primary Instead, what I see is LOG: database system was interrupted; last known up at 2015-04-09 16:35:05 GMT LOG: entering standby mode LOG: redo starts at 0/E000028 LOG: consistent recovery state reached at 0/E0000F0 What am I doing wrong?
What interface is the primary database listening on? http://www.postgresql.org/docs/9.4/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS listen_addresses (string) Can you connect remotely from the standby using psql?
-- *Volkan Unsal* /web and mobile development/ volkanunsal.com <http://bit.ly/1h1ebjy>
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
