From: Tom Lane <tgl@sss.pgh.pa.us>
To: pramod kg <pramod11287@gmail.com>
cc: Thomas Kellerer <shammat@gmx.net>, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL local connection is taking 4 seconds
In-reply-to: 
 <CAHkcXnw9PeYUQoQRKCHU2d7YXZudjPjVYG5cwgER1Z_NFZWrJg@mail.gmail.com>
References: 
 <CAHkcXnyVu3HJSrzRu9KA0T9cLgJxSkHfW2tYJdBg+ozYxZy_qw@mail.gmail.com>
 <006c932a-d986-d0d1-61cd-065ffbe71fb3@gmx.net>
 <4096247.1704212846@sss.pgh.pa.us>
 <CAHkcXnw9PeYUQoQRKCHU2d7YXZudjPjVYG5cwgER1Z_NFZWrJg@mail.gmail.com>
Comments: In-reply-to pramod kg <pramod11287@gmail.com>
	message dated "Wed, 03 Jan 2024 12:35:21 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <202846.1704297360.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 03 Jan 2024 10:56:00 -0500
Message-ID: <202847.1704297360@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/202847.1704297360%40sss.pgh.pa.us>
Precedence: bulk

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 a=
re
> faster.
> export PGGSSENCMODE=3D"disable"

Ah, that rings a bell.  After a bit of searching I found

https://www.postgresql.org/message-id/flat/16897-2632c6541c9f8491%40postgr=
esql.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