Can we use fqdn in pg_hba.conf for replication connections?
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 0.0.0.0/0 md5
host replication postgres slave.example.com trust
I am getting below error in slave
2017-10-10 21:34:52 UTC [313]: [1-1] user= db= host= FATAL: could not connect to the primary server: FATAL: no pg_hba.conf entry for replication connection from host "10.10.10.10", user "postgres", SSL off where "10.10.10.10" is my slave (slave.example.com) ip.
Thanks,
Ram