| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pramod kg <pramod11287(at)gmail(dot)com> |
| Cc: | Thomas Kellerer <shammat(at)gmx(dot)net>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL local connection is taking 4 seconds |
| Date: | 2024-01-03 15:56:00 |
| Message-ID: | 202847.1704297360@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
pramod kg <pramod11287(at)gmail(dot)com> writes:
> We have made some progress. GSSAPI authentication method is taking time
> though we have not enabled the GSSAPI authentication method in postgres
> (but the connection request is spending some time there). We continue
> troubleshooting on why the GSSAPI authentication method is taking longer
> time. For now we have exported the following ENV and local connections are
> faster.
> export PGGSSENCMODE="disable"
Ah, that rings a bell. After a bit of searching I found
https://www.postgresql.org/message-id/flat/16897-2632c6541c9f8491%40postgresql.org
which seems to describe exactly the same symptom. We never got a
final answer from that person, but I continue to think that Postgres
must have been trying to use GSSAPI authentication, suggesting that
the server is being started in an environment where a GSSAPI server
appears to be available.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2024-01-03 17:59:49 | Re: PostgreSQL local connection is taking 4 seconds |
| Previous Message | David G. Johnston | 2024-01-03 15:11:57 | Re: Vacuum |