pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcreateuser error
5+ messages / 2 participants
[nested] [flat]
* createuser error
@ 2004-06-06 05:06 Dan Thompson <dthompson@wv-cis.net>
0 siblings, 0 replies; 5+ messages in thread
From: Dan Thompson @ 2004-06-06 05:06 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* createuser error
@ 2004-06-06 11:54 Dan Thompson <dthompson@wv-cis.net>
0 siblings, 1 reply; 5+ messages in thread
From: Dan Thompson @ 2004-06-06 11:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createuser error
@ 2004-06-06 15:54 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dan Thompson <dthompson@wv-cis.net>
0 siblings, 2 replies; 5+ messages in thread
From: Tom Lane @ 2004-06-06 15:54 UTC (permalink / raw)
To: Dan Thompson <dthompson@wv-cis.net>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createuser error
@ 2004-06-09 00:57 Dan Thompson <dthompson@wv-cis.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Dan Thompson @ 2004-06-09 00:57 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createuser error
@ 2004-06-09 01:53 Dan Thompson <dthompson@wv-cis.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Dan Thompson @ 2004-06-09 01:53 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-06-09 01:53 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-06 05:06 createuser error Dan Thompson <dthompson@wv-cis.net>
2004-06-06 11:54 createuser error Dan Thompson <dthompson@wv-cis.net>
2004-06-06 15:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-09 00:57 ` Dan Thompson <dthompson@wv-cis.net>
2004-06-09 01:53 ` Dan Thompson <dthompson@wv-cis.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox