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

Excellent! Thanks so much.

On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 05/14/2013 09:17 PM, Mike Christensen wrote:
>
>> If I have this:
>>
>> CREATE OR REPLACE VIEW Link.Foo AS
>> select * from dblink(
>> 'hostaddr=123.123.123.123 dbname=KitchenPC user=Website
>> password=secret',
>> 'select * from Foo') as ...
>>
>> Then it works. However, if I do:
>>
>> CREATE OR REPLACE VIEW Link.Foo AS
>> select * from dblink(
>> 'hostaddr=db.domain.com <http://db.domain.com> dbname=KitchenPC
>>
>> user=Website password=secret',
>> 'select * from Foo') as ...
>>
>> Then I get:
>>
>> ERROR: could not establish connection
>> DETAIL: could not translate host name "db.domain.com
>> <http://db.domain.com>" to address: Unknown host
>>
>>
>> However, from a command prompt I can ping db.domain.com
>> <http://db.domain.com> and get 123.123.123.123.
>>
>>
>> Does dblink just not support DNS resolution? I really don't want to
>> hard code IP addresses in my scripts. Thanks!
>>
>
> See below for explanation of hostaddr and host. Short version, you are
> looking for host:
>
> http://www.postgresql.org/**docs/9.2/interactive/libpq-**
> connect.html#LIBPQ-**PARAMKEYWORDS<http://www.postgresql.org/docs/9.2/interactive/libpq-connect.html#LIBPQ-PARAMKEYWORDS>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>