X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 96AF8D1B349 for ; Tue, 8 Jun 2004 21:55:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81172-08 for ; Wed, 9 Jun 2004 00:55:37 +0000 (GMT) Received: from mail.wv-cis.net (mail.wv-cis.net [209.197.41.6]) by svr1.postgresql.org (Postfix) with ESMTP id BBB7ED1B431 for ; Tue, 8 Jun 2004 21:55:32 -0300 (ADT) Received: from usr-209-197-041-240.wv-cis.net ([209.197.41.240]) by mail.wv-cis.net (CIS Internet Secure Mail Server v7.4.0) with ESMTP id X3J05152 for ; Tue, 08 Jun 2004 20:55:37 -0400 Subject: Re: createuser error From: Dan Thompson To: pgsql-admin@postgresql.org In-Reply-To: <203.1086537284@sss.pgh.pa.us> References: <78d5065b70bd12a86c85b691ad7cbde3819dfdb5@postgresql.org> <1086522894.11416.8.camel@localhost.localdomain> <203.1086537284@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="=-dVLp8UVn9xK282xtw2OB" Message-Id: <1086742633.12281.7.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-1) Date: Tue, 08 Jun 2004 20:57:13 -0400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_FONTCOLOR_UNSAFE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/97 X-Sequence-Number: 13757 --=-dVLp8UVn9xK282xtw2OB Content-Type: text/plain Content-Transfer-Encoding: 7bit On Sun, 2004-06-06 at 11:54, Tom Lane wrote: > Dan Thompson 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 --=-dVLp8UVn9xK282xtw2OB Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit On Sun, 2004-06-06 at 11:54, Tom Lane wrote:
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
--=-dVLp8UVn9xK282xtw2OB--