dblink does not connect when activated in a remote server

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: dblink does not connect when activated in a remote server
Date: 2007-12-18 11:24:24
Message-ID: E9DE7963E5EA6546B42A979EC28B4D0136C168D0@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Goboxe 2007-12-18 11:47:15 Partitioned tables & Slony
Previous Message Martijn van Oosterhout 2007-12-18 10:09:25 Re: postgres8.3beta encodding problem?