From dthompson@wv-cis.net Sun Jun 6 05:04:52 2004 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 185A0D1B33D for ; Sun, 6 Jun 2004 02:04:52 -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 32686-05 for ; Sun, 6 Jun 2004 05:04:43 +0000 (GMT) Received: from mail.wv-cis.net (mail.wv-cis.net [209.197.41.6]) by svr1.postgresql.org (Postfix) with ESMTP id 8265AD1B189 for ; Sun, 6 Jun 2004 02:04:39 -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 ; Sun, 06 Jun 2004 01:04:38 -0400 Subject: createuser error From: Dan Thompson To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-khKKwwBgRNxtpS3tkQJx" Message-Id: <1086498368.12526.13.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-1) Date: Sun, 06 Jun 2004 01:06:09 -0400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/63 X-Sequence-Number: 13723 --=-khKKwwBgRNxtpS3tkQJx Content-Type: text/plain Content-Transfer-Encoding: 7bit I'm new to pgsql. I'm trying to install sql-ledger featured in Linux Journal The install instructions saay to create the db admin account by: bash$ createuser -D sql-ledger This returns this error: createuser: relocation error: createuser: undefined symbol: get_progname Even if I only typ: createuser I get the exact same error. I have read about how to create a user but I can't find where this error has popped up before. I have made usre the database has been initialized and that the server process is running. Any ideas? --=-khKKwwBgRNxtpS3tkQJx Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit I'm new to pgsql. I'm trying to install sql-ledger featured in Linux Journal
The install instructions saay to create the db admin account by:
bash$ createuser -D sql-ledger

This returns this error:
createuser: relocation error: createuser: undefined symbol: get_progname

Even if I only typ: createuser I get the exact same error.

I have read about how to create a user but I can't find where this error has popped up before.

I have made usre the database has been initialized and that the server process is running.

Any ideas?

--=-khKKwwBgRNxtpS3tkQJx-- From dthompson@wv-cis.net Sun Jun 6 11:54:52 2004 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 1A307D1B272 for ; Sun, 6 Jun 2004 08:54:52 -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 39877-02 for ; Sun, 6 Jun 2004 11:54:01 +0000 (GMT) Received: from mail.wv-cis.net (mail.wv-cis.net [209.197.41.6]) by svr1.postgresql.org (Postfix) with ESMTP id 8F56AD1B276 for ; Sun, 6 Jun 2004 08:53: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 ; Sun, 06 Jun 2004 07:53:23 -0400 Subject: createuser error From: Dan Thompson To: pgsql-admin@postgresql.org In-Reply-To: <78d5065b70bd12a86c85b691ad7cbde3819dfdb5@postgresql.org> References: <78d5065b70bd12a86c85b691ad7cbde3819dfdb5@postgresql.org> Content-Type: multipart/alternative; boundary="=-aLCQ4F8c16V6KDKS5Zqk" Message-Id: <1086522894.11416.8.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-1) Date: Sun, 06 Jun 2004 07:54:54 -0400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/57 X-Sequence-Number: 13717 --=-aLCQ4F8c16V6KDKS5Zqk Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, I'm new to databases. I'm using version 7.4 on Red Hat Enterprise Linux 3. I'm trying to install sql-ledger featured in a recent article in Linux Journal. Postgres is running, and I haved initialized the database. The next step seems to be creating the program user. My instructions say to : # su postgres $ createuser -d sql-ledger I get this error: createuser: relocation error: createuser: undefined symbol: get_progname I don't really know where to go from here. Thanks, Dan Thompson --=-aLCQ4F8c16V6KDKS5Zqk Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi, I'm new to databases.

I'm using version 7.4 on Red Hat Enterprise Linux 3. I'm trying to install sql-ledger featured in a recent article in Linux Journal. Postgres is running, and I haved initialized the database. The next step seems to be creating the program user. My instructions say to :

# su postgres
$ createuser -d sql-ledger

I get this error:

createuser: relocation error: createuser: undefined symbol: get_progname

I don't really know where to go from here.

Thanks,
Dan Thompson --=-aLCQ4F8c16V6KDKS5Zqk-- From tgl@sss.pgh.pa.us Sun Jun 6 15:54:48 2004 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 From dthompson@wv-cis.net Wed Jun 9 00:55:38 2004 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-- From dthompson@wv-cis.net Wed Jun 9 01:52:09 2004 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 51587D1B26D for ; Tue, 8 Jun 2004 22:52:09 -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 12514-04 for ; Wed, 9 Jun 2004 01:52:08 +0000 (GMT) Received: from mail.wv-cis.net (mail.wv-cis.net [209.197.41.6]) by svr1.postgresql.org (Postfix) with ESMTP id 3A98BD1B243 for ; Tue, 8 Jun 2004 22:52:04 -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; Tue, 08 Jun 2004 21:52:09 -0400 Subject: Re: createuser error From: Dan Thompson To: Tom Lane Cc: 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="=-H7gkz985dx1SQnLTeUj1" Message-Id: <1086746025.12281.10.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-1) Date: Tue, 08 Jun 2004 21:53:45 -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/99 X-Sequence-Number: 13759 --=-H7gkz985dx1SQnLTeUj1 Content-Type: text/plain Content-Transfer-Encoding: 7bit Tom, or anyone, I removed and then reinstalled. I was wrong about the version. It IS 7.3.x. I cannot start the server now, though. it says: postgresql failed. The error was: An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgresql-7.3/README.rpm-dist for more information. I don't have any data yet, so if I just need to delete a file? I can. I just don't know which one. I installed using apt for rpm, thinking that everything would be done correctly. :- Sorry about the bad posts. Long day. :-) Thanks, Dan 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 --=-H7gkz985dx1SQnLTeUj1 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Tom, or anyone,

I removed and then reinstalled. I was wrong about the version. It IS 7.3.x. I cannot start the server now, though. it says:
postgresql failed. The error was:
An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgresql-7.3/README.rpm-dist for more information.
I don't have any data yet, so if I just need to delete a file? I can. I just don't know which one.
I installed using apt for rpm, thinking that everything would be done correctly. :-

Sorry about the bad posts. Long day. :-)

Thanks,

Dan


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
--=-H7gkz985dx1SQnLTeUj1--