Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8sjC-00CJBK-4M for pgsql-general@arkaria.postgresql.org; Fri, 01 Dec 2023 01:54:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8sjA-004Pa1-E9 for pgsql-general@arkaria.postgresql.org; Fri, 01 Dec 2023 01:54:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8sjA-004PZr-38 for pgsql-general@lists.postgresql.org; Fri, 01 Dec 2023 01:54:00 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8sj4-009SSN-CM for pgsql-general@postgresql.org; Fri, 01 Dec 2023 01:53:59 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 3B11rpUm012251; Thu, 30 Nov 2023 20:53:51 -0500 From: Tom Lane To: John DeSoi cc: Joe Conway , Postgres General Subject: Re: libpq crashing on macOS during connection startup In-reply-to: <0100018c22fc6f53-68a3de31-0c8c-4305-a889-fb23b5732596-000000@email.amazonses.com> References: <0100018c20b152e0-ec85ac20-b379-46d7-a962-c59e00f3201c-000000@email.amazonses.com> <96e41ee8-a1b6-4bf9-82b5-1c0fd2d5502a@joeconway.com> <0100018c20c97a5e-2aa47402-cd8c-4548-bbd3-b17d10020b39-000000@email.amazonses.com> <508800.1701374869@sss.pgh.pa.us> <0100018c22fc6f53-68a3de31-0c8c-4305-a889-fb23b5732596-000000@email.amazonses.com> Comments: In-reply-to John DeSoi message dated "Fri, 01 Dec 2023 01:26:58 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <12249.1701395631.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 30 Nov 2023 20:53:51 -0500 Message-ID: <12250.1701395631@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk John DeSoi writes: > On Nov 30, 2023, at 2:07 PM, Tom Lane wrote: >> What troubles me about that stack trace is the references to Heimdal. >> We gave up supporting Heimdal (and v16 explicitly rejects building >> with it) because its support for Kerberos credentials was too >> incomplete and flaky. So I'm inclined to guess that you are running >> into some Heimdal bug. Try to rebuild libpq using MIT Kerberos >> and see if things get better. > Is there a way to simply disable GSSAPI authentication? I could not find= it. gssencmode=3Ddisable in your connection options; but that's a tad inconvenient probably. > The otool output below shows that Apple's Kerberos is being used and I a= ssume by extension, their Heimdal library. The Heimdal project told me as = much - Apple has a fork and would not pull from their project. Ugh, not only Heimdal but a very obsolete version thereof? It borders on negligence for the homebrew PG package to be building against that. They should be pulling in homebrew's MIT Kerberos package and using that, if they want to enable GSSAPI. regards, tom lane