Thread: BUG #17988: psql generates segfault when connecting to remote database

The following bug has been logged on the website:

Bug reference:      17988
Logged by:          Matt Hughes
Email address:      hughes.matt@gmail.com
PostgreSQL version: 14.8
Operating system:   OS X
Description:

It seems like the 14.8 upgrade has caused pretty consistent segfaults when
trying to connect to any remote database.  I tried re-installing from
Homebrew but not having any luck.

> psql -V
psql (PostgreSQL) 14.8 (Homebrew)
> psql -Uuser -ddb -hremote_host -p5432
[1]    6358 segmentation fault  psql -Uuser -ddb -hremote_host -p5432

> uname -a
Darwin RESML-1730566 22.5.0 Darwin Kernel Version 22.5.0: Mon Apr 24
20:52:24 PDT 2023; root:xnu-8796.121.2~5/RELEASE_ARM64_T6000 arm64

> system_profiler SPSoftwareDataType SPHardwareDataType
Software:

    System Software Overview:

      System Version: macOS 13.4 (22F66)
      Kernel Version: Darwin 22.5.0
      Boot Volume: Macintosh HD
      Boot Mode: Normal
      Secure Virtual Memory: Enabled
      System Integrity Protection: Enabled
      Time since boot: 24 minutes, 18 seconds

Hardware:

    Hardware Overview:

      Model Name: MacBook Pro
      Model Identifier: MacBookPro18,3
      Model Number: Z15G001X7LL/A
      Chip: Apple M1 Pro
      Total Number of Cores: 10 (8 performance and 2 efficiency)
      Memory: 32 GB
      System Firmware Version: 8422.121.1
      OS Loader Version: 8422.121.1

PG Bug reporting form <noreply@postgresql.org> writes:
> It seems like the 14.8 upgrade has caused pretty consistent segfaults when
> trying to connect to any remote database.

FWIW, I can't reproduce any such problem on my own MacBook Pro,
nor do we have any similar reports.  I suspect it may have
something to do with the specific versions of support libraries
(e.g. openssl) that you're linking to.  It's hard to speculate
profitably with so little detail, though.

            regards, tom lane