I have Postgres replication (master & slave).

The slave server has 2 local IP addresses ( & As far as I know the streaming replication worked fine with slave using But somehow the slave could not connect to master because it required another IP:

2017-01-30 23:53:13.510 WIB >FATAL: no pg_hba.conf entry for replication connection from host "", user "user1", SSL off

I can put in pg_hba.conf to work around this problem. I want to know if I did anything wrong to make the slave Postgres IP change? It was working just fine.

  • How is the connection specified in recovery.conf? – dezso Jan 31 '17 at 9:18

This is not the question about PostgreSQL - this is about routing. Just route from became as better than from

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.