From: Stephen Frost <sfrost@snowman.net>
To: rich.crampton@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16897: gssenc request slow connection
Date: Thu, 25 Feb 2021 12:43:51 -0500
Message-ID: <20210225174351.GU20766@tamriel.snowman.net> (raw)
In-Reply-To: <16897-2632c6541c9f8491@postgresql.org>
References: <16897-2632c6541c9f8491@postgresql.org>
Greetings,
* PG Bug reporting form (noreply@postgresql.org) wrote:
> Email address: rich.crampton@gmail.com
> PostgreSQL version: 12.6
> Operating system: client Windows 10, postgresql server Ubuntu
> Description:
>
> When connecting over a local network from Windows 10 to PostgreSQL server
> (Linux version 12.6 default install) the gssencmode=prefer in libpq
> connection causes a big slowdown.
>
> With "gssencmode=prefer" connection takes 4 seconds.
> With "gssencmode=disable" connection as fast as normal.
>
> As the prefer option is the default option this causes problems in dependent
> libraries such as psycopg2 for Python. First raised the bug here
> https://github.com/psycopg/psycopg2/issues/1242 but I think this must be a
> libpq/Postgresql bug since psycopg2 is just passing along the request.
What's the version of the libpq library on the client side..? In
general, while there's an extra packet back and forth because Kerberos /
GSSAPI is set up on the client / Windows side, once the server says it
doesn't support GSSENC, libpq should try a non-GSSENC connection right
away..
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
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-bugs@postgresql.org
Cc: sfrost@snowman.net, rich.crampton@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16897: gssenc request slow connection
In-Reply-To: <20210225174351.GU20766@tamriel.snowman.net>
* 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