| 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: | Whole Thread | Raw Message | 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 |