+postgresql+thewild+ac82708ba6.postgresql.*.thewild#spamgourmet.com@spamgourmet.com a écrit :
> 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
>
OK I've got it : I had to use "host=..." instead of "hostaddr=...".
Seems obvious now that I know it.
Regards
--
Arnaud