dblink_connect is slow

--0016e6d99b832c626104833c341b
Content-Type: text/plain; charset=ISO-8859-1

Hi

Using Postgresql 8.2 on Linux, I am trying to use dblink contrib to connect
to a remote Postresql 8.2 database. I am using the following SQL :

select dblink_connect('host=remote_server port=5432 dbname=remote_bdd
user=remote_user password=remote_pwd');

The problem is :
- when remote_server entry exists in /etc/hosts file, the connexionis
immediate
- but when remote_server entry does not exists in /etc/hosts file, the
connexion take 1 minute

However, even if remote_server entry does not exists in /etc/hosts file, I
can ping immediately the remote_server and a remote psql connexion (using
"psql -h remote_server -d remote_bdd") is also immediate, so I don't think
that my network or DNS server could be the problem

Is the something particular with dblink_connect function that could explain
that a remote connexion is so long ?

Thank you by advance fore your help

Jeff

--0016e6d99b832c626104833c341b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi

Using Postgresql 8.2 on Linux, I am trying to use dblink contrib =
to connect to a remote Postresql 8.2 database. I am using the following SQL=
:

select dblink_connect('host=3Dremote_server=20
port=3D5432 dbname=3Dremote_bdd user=3Dremote_user password=3Dremote_pwd=
9;);

The problem is :
- when remote_server entry exists in /etc/h=
osts file, the connexionis immediate
- but when remote_server entry does=
not exists in /etc/hosts file, the connexion take 1 minute


However, even if remote_server entry does not exists in /etc/hosts file=
, I can ping immediately the remote_server and a remote psql connexion (usi=
ng "psql -h remote_server -d remote_bdd") is also immediate, so I=
don't think that my network or DNS server could be the problem


Is the something particular with dblink_connect function that could exp=
lain that a remote connexion is so long ?

Thank you by advance fore =
your help

Jeff


--0016e6d99b832c626104833c341b--

Re: dblink_connect is slow

scheu dba wrote:

> - when remote_server entry exists in /etc/hosts file, the
> connexionis immediate
> - but when remote_server entry does not exists in /etc/hosts file,
> the connexion take 1 minute

You might want to check that the server has a reverse DNS entry (to
map the IP address back to a server name).

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin