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 011F5D1B4A9 for ; Sun, 6 Jun 2004 12:54:48 -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 91023-10 for ; Sun, 6 Jun 2004 15:54:47 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 89A24D1B187 for ; Sun, 6 Jun 2004 12:54:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i56FsjrG000204; Sun, 6 Jun 2004 11:54:45 -0400 (EDT) To: Dan Thompson Cc: pgsql-admin@postgresql.org Subject: Re: createuser error In-reply-to: <1086522894.11416.8.camel@localhost.localdomain> References: <78d5065b70bd12a86c85b691ad7cbde3819dfdb5@postgresql.org> <1086522894.11416.8.camel@localhost.localdomain> Comments: In-reply-to Dan Thompson message dated "Sun, 06 Jun 2004 07:54:54 -0400" Date: Sun, 06 Jun 2004 11:54:44 -0400 Message-ID: <203.1086537284@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/58 X-Sequence-Number: 13718 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