pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dan Thompson <dthompson@wv-cis.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: createuser error
Date: Tue, 08 Jun 2004 21:53:45 -0400
Message-ID: <1086746025.12281.10.camel@localhost.localdomain> (raw)
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>

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

view thread (5+ messages)

Message-ID: <1086746025.12281.10.camel@localhost.localdomain>
Permalink:  ../1086746025.12281.10.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1086746025.12281.10.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dthompson@wv-cis.net, tgl@sss.pgh.pa.us
  Subject: Re: createuser error
  In-Reply-To: <1086746025.12281.10.camel@localhost.localdomain>
  References: <78d5065b70bd12a86c85b691ad7cbde3819dfdb5@postgresql.org> <1086522894.11416.8.camel@localhost.localdomain> <203.1086537284@sss.pgh.pa.us> <1086746025.12281.10.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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