dblink does not connect when activated in a remote server

Поиск
Список
Период
Сортировка
От Abraham, Danny
Тема dblink does not connect when activated in a remote server
Дата
Msg-id E9DE7963E5EA6546B42A979EC28B4D0136C168D0@hou-ex-02.adprod.bmc.com
обсуждение исходный текст
Ответы Re: dblink does not connect when activated in a remote server  (Terry Fielder <terry@ashtonwoodshomes.com>)
Список 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


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: postgres8.3beta encodding problem?
Следующее
От: Terry Fielder
Дата:
Сообщение: Re: dblink does not connect when activated in a remote server