How to change PostgreSQL IP address for streaming replication [closed]

Posted on

Question :

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.

Answer :

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

Leave a Reply

Your email address will not be published. Required fields are marked *