PostgeSQL problem

[Eckard Brauer]

Hi,

as there is/are some malloc error(s), everything could simply be caused
by some broken binary. So please check, if the problem remains when
providing user credentials ("-U user -P password" or at least "-U
user").

Usually psql will connect with the (system) user's login name if no "-U
db-user" arg is given. So either you tried to connect as a different
user with no DB account (each user account has to be added to the DB
before, as system and DB users are completely independent, or the
upgrade has set up a completely new database, where no (ordinary)
system user has yet an account. That happens (I have a server on a
linux box) with major updates (14 to 15 or the like).

Hope it helps.

Best,
Eckard

Am Sat, 25 Nov 2023 11:59:46 +0000
schrieb Bill Hill via macports-users
<macports-users at lists.macports.org>:

> Hi,
> I've run a MacPorts update, and now postgres is broken.
[..]
> 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? Thanks. Bill



-- 
Diese Mail wurde ausschließlich aus klimaneutralen Bits und Bytes
erzeugt. This mail was generated exclusively from climate-neutral bits
and bytes.