PostgeSQL problem

[Clemens Lang]

On Sat, Nov 25, 2023 at 11:59:46AM +0000, Bill Hill via macports-users wrote:
> Hi,
> I've run a MacPorts update, and now postgres is broken.
> I did:
>   sudo port selfupdate && sudo port upgrade outdated && sudo port -N reclaim
> which upgraded about a dozen ports, the only ones of which I remember were:
>   exa, py310-mypy and py311-mypy
> Now some years old scripts using psql no longer work.
> The command that tripped up:
>   psql --host=raidbox.lan sen01 senlog -c "SELECT COUNT(*) FROM weather WHERE dtstamp>(TIMEZONE('utc', NOW())-'1 hour'::INTERVAL)"
> The error:
>   psql: error: connection to server at "raidbox.lan", port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
>   connection to server at "raidbox.lan", port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
>   psql(31651,0x7ff844dff9c0) malloc: *** error for object 0xab: pointer being freed was not allocated
>   psql(31651,0x7ff844dff9c0) malloc: *** set a breakpoint in malloc_error_break to debug
>   Abort trap: 6
> I get about the same messages from /opt/local/bin/psql13 and /opt/local/bin/psql15 (15 is active)
> It isn't a server problem; I can run the query on the server, and on a linux box, and on a Debian VM under Parallels.
> Also, I tried installing the brew version:
>   brew install postgresql at 16
> And /usr/local/Cellar/postgresql at 16/16.1/bin/psql works.
> In addition, /opt/local/bin/pgcli gives:
>   Illegal instruction: 4
> And qt5-psql-plugin @5.15.11_0+postgresql13 and octave-database don't work either.
> How can I find out what's broken, and how can I fix this?

That seems to be

  https://trac.macports.org/ticket/68777

I'd suggest adding yourself to the Cc list of that ticket.

-- 
Clemens