Re: Slow Remote connection
От | Tom Lane |
---|---|
Тема | Re: Slow Remote connection |
Дата | |
Msg-id | 13796.1025536744@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Slow Remote connection (Jean-Arthur Silve <jeanarthur@eurovox.fr>) |
Список | pgsql-admin |
Jean-Arthur Silve <jeanarthur@eurovox.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
В списке pgsql-admin по дате отправления: