Search Postgresql Archives

Re: dblink does not resolve DNS, but works with IP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ah, gotcha!  I guess whatever sample I was originally copying from used hostaddr for some reason..  Thanks for the clarification, Tom!


On Wed, May 15, 2013 at 6:08 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Mike Christensen <mike@xxxxxxxxxxxxx> writes:
> Though I'm a bit curious why there's a host and hostaddr.  Why can't it
> just resolve whatever you give it?

Well, it will ... if you use the "host" parameter.  The whole point of
"hostaddr" is that for that parameter, it will not try a DNS lookup.
You'd only use that if you had issues with the speed or reliability
of your DNS service.

                        regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux