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@16
And /usr/local/Cellar/postgresql@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?
Thanks.
Bill