Re: [pgsql-es-ayuda] Conexión a PostgreSQL con nombre de dominio

ejecute dig en asmita y me arroja esto:

; <<>> DiG 9.9.5-3ubuntu0.7-Ubuntu <<>> -x 192.168.15.53
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 59685
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 1280
;; QUESTION SECTION:
;53.15.168.192.in-addr.arpa. IN PTR

;; AUTHORITY SECTION:
168.192.in-addr.arpa. 3600 IN SOA snpe-dc01.senape.gob.bo.
hostmaster.senape.gob.bo. 26923 900 600 86400 3600

;; Query time: 1 msec
;; SERVER: 192.168.15.24#53(192.168.15.24)
;; WHEN: Fri May 20 17:43:45 BOT 2016
;; MSG SIZE rcvd: 145

2016-05-20 17:38 GMT-04:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:

> Alvaro Herrera escribió:
>
> > Hmm. ¿y en asmita, qué dice dig -x 192.168.15.53? Debería resolver de
> > vuelta a srvdb-1.senape.gob.bo ... Si no, creo que te toca configurar el
> > reverso, aunque no recuerdo claramente si esta parte es obligatoria.
>
> 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 DNS
> lookup, 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 to are
> equal to the client's IP address. If both directions match,
> then the entry is considered to match. (The host name that is
> used in <filename>pg_hba.conf</filename> 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 host names, but
> the operating system will only return one host name when asked
> to resolve an IP address.)
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>