dblink does not resolve DNS, but works with IP

Поиск

Список

Период

Сортировка

От	Mike Christensen
Тема	dblink does not resolve DNS, but works with IP
Дата	15 мая 2013 г. 07:17:10
Msg-id	CABs1bs3QHApudo0pLyJ-8f-7DKGvBPsHpXRyzq-ZU3FTbDWQYQ@mail.gmail.com обсуждение исходный текст
Ответы	Re: dblink does not resolve DNS, but works with IP (Adrian Klaver <adrian.klaver@gmail.com>)
Список	pgsql-general

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 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" to address: Unknown host

However, from a command prompt I can ping 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!

В списке pgsql-general по дате отправления:

От: Jeff Janes
Дата: 15 мая 2013 г., 06:57:07
Сообщение: Re: Running out of memory at vacuum

От: "Greg Sabino Mullane"
Дата: 15 мая 2013 г., 07:24:17
Сообщение: Re: How to convert numbers into words in postgresql