dblink and hostname resolution problem

Поиск
Список
Период
Сортировка
От postgresql.*.thewild@spamgourmet.com
Тема dblink and hostname resolution problem
Дата
Msg-id 4715E9F3.7050004@supermail.fr
обсуждение исходный текст
Ответы Re: dblink and hostname resolution problem
Список pgsql-general
Hi list!

I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on another similar system (Win32 /
PostgreSQL8.2). 
If I query the server with dblink('hostaddr=ip_address ...', ...), it works fine, but if I try to use the hostname
instead(dblink('hostaddr=myserver.mydomain.com ...', ...)), I have an error : 

ERROR:  could not establish connection
DETAIL:  could not translate host name "myserver.mydomain.com" to address: Unknown server error

Both server can resolve this address though.
Is this a known issue ? Is there something I can do about it ?

Thansk a lot !

Regards
--
Arnaud

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

Предыдущее
От: "Sergey Konoplev"
Дата:
Сообщение: Re: pg_cancel_backend() does not work with buzz queries
Следующее
От: Syan Tan
Дата:
Сообщение: Re: atomic commit;begin for long running transactions , in combination with savepoint.