Re: PostgreSQL local connection is taking 4 seconds - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgreSQL local connection is taking 4 seconds
Date
Msg-id 202847.1704297360@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL local connection is taking 4 seconds  (pramod kg <pramod11287@gmail.com>)
List pgsql-admin
pramod kg <pramod11287@gmail.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



pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Vacuum
Next
From: Jeff Janes
Date:
Subject: Re: PostgreSQL local connection is taking 4 seconds