Re: libpq crashing on macOS during connection startup

2023-12-04 Thread John DeSoi
> On Nov 30, 2023, at 7:53 PM, Tom Lane wrote: > >> Is there a way to simply disable GSSAPI authentication? I could not find it. > > gssencmode=disable in your connection options; but that's a tad > inconvenient probably. I discovered there is a PGGSSENCMODE environment variable. I set it to

Re: libpq crashing on macOS during connection startup

2023-12-01 Thread John DeSoi
> On Dec 1, 2023, at 11:02 AM, Tom Lane wrote: > > I'd suggest filing a bug against Homebrew's krb5 package. > Whatever this is, it seems pretty clear that it's not a > Postgres bug. Will do, thank you and everyone else for the help and feedback. John DeSoi, Ph.D.

Re: libpq crashing on macOS during connection startup

2023-12-01 Thread Tom Lane
John DeSoi writes: >> On Nov 30, 2023, at 7:53 PM, Tom Lane wrote: >> 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

Re: libpq crashing on macOS during connection startup

2023-12-01 Thread John DeSoi
> On Nov 30, 2023, at 7:53 PM, Tom Lane wrote: > > gssencmode=disable in your connection options; but that's a tad > inconvenient probably. Yes, the application uses PHP PDO to connect to PostgreSQL. I don't see any way to specify that in the connection options. > Ugh, not only Heimdal but

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Tom Lane
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

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread John DeSoi
> 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

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Tom Lane
John DeSoi writes: >> On Nov 30, 2023, at 8:59 AM, Joe Conway wrote: >> Did you recently get an OpenSSL upgrade to v3.2.0? This is a shot in the >> dark, but perhaps related to the discussion here? >> https://www.postgresql.org/message-id/flat/CAN55FZ1eDDYsYaL7mv%2BoSLUij2h_u6hvD4Qmv-7PK7jkji0uy

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread John DeSoi
> On Nov 30, 2023, at 10:21 AM, Adrian Klaver wrote: > > To be clear, at the times the Web processes crash there is are no traces in > the Postgres log of an issue on the Postgres side? > > Is there evidence in the Postgres logs of what the Web process was doing just > before it crashed? N

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Adrian Klaver
On 11/30/23 07:49, John DeSoi wrote: On Nov 30, 2023, at 9:36 AM, Adrian Klaver wrote: What starts happening? Random web process crashes when connecting to PostgreSQL. Does the Postgres log show anything? No. To be clear, at the times the Web processes crash there is are no traces

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread John DeSoi
> On Nov 30, 2023, at 9:36 AM, Adrian Klaver wrote: > > What starts happening? Random web process crashes when connecting to PostgreSQL. > > Does the Postgres log show anything? No. > > Postgres version? > > How was Postgres installed? PostgreSQL 15.4 installed with Homebrew. John

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Adrian Klaver
On 11/30/23 06:45, John DeSoi wrote: I have a macOS web server using Postgres that has been very stable until a month or two ago. If I restart the web server the problem seems to go away for a while, but starts happening again within days. I thought it was a PHP issue as discussed in the link

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread John DeSoi
> On Nov 30, 2023, at 8:59 AM, Joe Conway wrote: > > Did you recently get an OpenSSL upgrade to v3.2.0? This is a shot in the > dark, but perhaps related to the discussion here? > > https://www.postgresql.org/message-id/flat/CAN55FZ1eDDYsYaL7mv%2BoSLUij2h_u6hvD4Qmv-7PK7jkji0uyQ%40mail.gmail.c

Re: libpq crashing on macOS during connection startup

2023-11-30 Thread Joe Conway
On 11/30/23 09:45, John DeSoi wrote: I have a macOS web server using Postgres that has been very stable until a month or two ago. If I restart the web server the problem seems to go away for a while, but starts happening again within days. I thought it was a PHP issue as discussed in the link

libpq crashing on macOS during connection startup

2023-11-30 Thread John DeSoi
I have a macOS web server using Postgres that has been very stable until a month or two ago. If I restart the web server the problem seems to go away for a while, but starts happening again within days. I thought it was a PHP issue as discussed in the link below, but I just noticed in the crash