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(dot)matt(at)gmail(dot)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