From: scheu dba <scheu.postgresql@gmail.com>
To: pgsql-admin@postgresql.org
Subject: dblink_connect is slow
Date: Fri, 2 Apr 2010 09:48:23 +0200
Message-ID: <i2iac2983ab1004020048p2f4bd905vf6c7948cb474eece@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scheu.postgresql@gmail.com
Subject: Re: dblink_connect is slow
In-Reply-To: <i2iac2983ab1004020048p2f4bd905vf6c7948cb474eece@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox