From: Tom Lane <tgl@sss.pgh.pa.us>
To: pramod kg <pramod11287@gmail.com>
Cc: Thomas Kellerer <shammat@gmx.net>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL local connection is taking 4 seconds
Date: Wed, 03 Jan 2024 10:56:00 -0500
Message-ID: <202847.1704297360@sss.pgh.pa.us> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, pramod11287@gmail.com, shammat@gmx.net, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL local connection is taking 4 seconds
In-Reply-To: <202847.1704297360@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox