Re: FQDN for replication connection in pg_hba.conf

On Tue, Oct 10, 2017 at 3:08 PM, rammohan ganapavarapu <
rammohanganap(at)gmail(dot)com> wrote:

> 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
> <http://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
> <http://slave.example.com>) * ip.
>
>
​The comments and note under "address" at the following link suggest that
what you are trying is possible. Hopefully they can shed some light as to
what to check in order to find out why it is not working in your case.​ In
particular, are both DNS entries configured?

https://www.postgresql.org/docs/10/static/auth-pg-hba-conf.html

​Ensure you reload the configuration after making changes.
​
​I don't recall whether having a all/all/any entry above your replication
entry is going to be problematic - but that wouldn't explain a "no
pg_hba.conf entry" error.

David J.