Re: createuser error - Mailing list pgsql-admin

From Tom Lane
Subject Re: createuser error
Date
Msg-id 203.1086537284@sss.pgh.pa.us
Whole thread Raw
In response to createuser error  (Dan Thompson <dthompson@wv-cis.net>)
Responses Re: createuser error
Re: createuser error
List pgsql-admin
Dan Thompson <dthompson@wv-cis.net> writes:
> I'm using version 7.4 on Red Hat Enterprise Linux 3.
> I get this error:
> createuser: relocation error: createuser: undefined symbol: get_progname

This is a fairly common symptom of a library version conflict.
get_progname() was added to libpq.so as of (IIRC) PG 7.4.  What you've
evidently got is a 7.4 createuser that is trying to use a 7.3-or-older
libpq.so.

RHEL3 shipped with PG 7.3-something, so the presence of the older
library isn't surprising.  Where did you install the newer one?
You probably need to fool with ldconfig to get the dynamic linker
to find the newer library instead of the older.  Or simply replace
the older library with the newer one in /usr/lib.

            regards, tom lane

pgsql-admin by date:

Previous
From: Dan Thompson
Date:
Subject: createuser error
Next
From: "todhunter"
Date:
Subject: Large database