Does the remote server have the relevant port opened up in its firewall?
Is postgres set to allow TCP/IP connections in the postgresql.conf?
Terry
Terry Fielder
terry@xxxxxxxxxxxxxxxxxx
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Abraham, Danny wrote:
dblink problem:
I am connecting to a remote server and run a functions that calls
another one using db_link.
It fails with the error message is 08001 - could not establish
connection.
When the function is located in a local server - it runs fine.
The connection string is:
'hostaddr=127.0.0.1 .....'
The following were tried but did not help:
'host=localhost' and even providing the real target server
('host=tlvl0390') did not help.
Happens on WIndows as well as Unix
Can you help?
Thanks
Danny
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
