[EMAIL PROTECTED] 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 / PostgreSQL 8.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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend