pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
createuser 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>
  2004-06-06 15:54 ` Re: createuser error Tom Lane <tgl@sss.pgh.pa.us>
  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 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   ` Re: createuser error Dan Thompson <dthompson@wv-cis.net>
  2004-06-09 01:53   ` Re: createuser error 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-06 11:54 createuser error Dan Thompson <dthompson@wv-cis.net>
  2004-06-06 15:54 ` Re: createuser error Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-06-09 00:57   ` Dan Thompson <dthompson@wv-cis.net>
  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-06 11:54 createuser error Dan Thompson <dthompson@wv-cis.net>
  2004-06-06 15:54 ` Re: createuser error Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-06-09 01:53   ` Dan Thompson <dthompson@wv-cis.net>
  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