Skip site navigation (1) Skip section navigation (2)

Re: Slow Remote connection

From: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Slow Remote connection
Date: 2002-07-01 12:41:57
Message-ID: 5.1.0.14.0.20020701143750.036a7680@mail.eurovox.fr (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-admin
Well...

I tried to connect with psql -h 127.0.0.1 mydb and it's slow (+/- 5 sec.) 
and psql mydb is fast ( less than 1 sec.) !

Here is my pg_hba :


.. few comments...
local      all                                          trust
host       all         127.0.0.1     255.255.255.255    trust
host       all         my_ip 255.255.255.255 trust


where my_ip is an IP address

May be I have a probleme with my system ?
version of the kernel is 2.4


jean-arthur




At 18:55 24/06/02 -0400, Tom Lane wrote:
>Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> writes:
> > I have a httpd server on one server, and PostgresQL 7.2 on a second server
> > (P4 1.7 Ghz / Linux ) on a local network.
>
> > When there are about 20 (and more ) connection on the DB, the remote
> > connecxtion to the DB from the web server is very long (about 5-10 sec)
> > before have the prompt.
>
> > On the local machine, it's near immediate.
>
>Weird.  Perhaps something wrong with your DNS setup, causing it to take
>a long time to resolve the name of the other machine?  Anyway I'd
>suspect that the problem is not within Postgres proper, given that
>you're not seeing a performance problem with local connections.
>
>Another thing you might try just to obtain more data is to test local
>connections that use TCP rather than Unix-socket transport, eg
>         psql -h 127.0.0.1
>
> > I use IP authentification (no username/password).
>
>You mean "trust"?  Please describe your pg_hba contents *exactly*;
>this might be a relevant difference ...
>
>                         regards, tom lane




In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2002-07-01 15:19:04
Subject: Re: Slow Remote connection
Previous:From: Dmitry MorozovskyDate: 2002-06-30 19:21:24
Subject: Re: TeDia2SQL 0.77 (Dia-->SQL DDL Tool) Released

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group