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