Re: dblink does not resolve DNS, but works with IP - Mailing list pgsql-general

From Mike Christensen
Subject Re: dblink does not resolve DNS, but works with IP
Date
Msg-id CABs1bs1_oVf4VDX9ysE0_uHkrkwt101YTkPyvUgTJtTTMRj=vQ@mail.gmail.com
Whole thread Raw
In response to Re: dblink does not resolve DNS, but works with IP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@sss.pgh.pa.us> wrote:
Mike Christensen <mike@kitchenpc.com> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: FATAL: database "a/system_data" does not exist
Next
From: Merlin Moncure
Date:
Subject: Re: Re: volatile void returning function not executed as often as expected in sql function