From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Slow Remote connection |
Date: | 2002-07-01 15:19:04 |
Message-ID: | 13796.1025536744@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> writes:
> 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 :
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all my_ip 255.255.255.255 trust
Weird. You're using trust in both cases, so there's no reason for
authentication to make any difference.
The only thing I can think of is that something is wrong with DNS name
resolution. Do you have hostname_lookup enabled in postgresql.conf?
Does changing it to the other setting make any difference? (Don't
forget to SIGHUP the postmaster after changing postgresql.conf, else
it won't notice.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2002-07-01 15:41:59 | Renaming a database |
Previous Message | Jean-Arthur Silve | 2002-07-01 12:41:57 | Re: Slow Remote connection |