rammohan ganapavarapu <rammohanganap@gmail.com> writes:
> Can we use fqdn in pg_hba.conf for replication connections?
Yes, if you're using 9.3 or newer, but note what the manual says:
If a host name is specified (anything that is not an IP address range or a special key word is treated as a host
name),that name is compared with the result of a reverse name resolution of the client's IP address (e.g., reverse
DNSlookup, if DNS is used). Host name comparisons are case insensitive. If there is a match, then a forward name
resolution(e.g., forward DNS lookup) is performed on the host name to check whether any of the addresses it resolves
toare equal to the client's IP address. If both directions match, then the entry is considered to match. (The host
namethat is used in pg_hba.conf should be the one that address-to-name resolution of the client's IP address
returns,otherwise the line won't be matched. Some host name databases allow associating an IP address with multiple
hostnames, but the operating system will only return one host name when asked to resolve an IP address.)
My bet is you don't have reverse DNS set up correctly for that address.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin