From: Richard Huxton <dev@archonet.com>
To: vijaykumar M <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: createlang plpgsql failing on redhatlinux7.2
Date: Fri, 12 Sep 2003 15:12:13 +0100
Message-ID: <200309121512.13546.dev@archonet.com> (raw)
In-Reply-To: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
References: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
Please don't post html-only messages to the list, it makes quoting hard...
On Friday 12 September 2003 14:49, vijaykumar M wrote:
> <P>We have a machine with RedhatLinix 7.2, on top of this i upgraded
> the postgresql7.3.3 version. After creating a database, i'm trying to
> create a language for that database by using <STRONG>createlang plpgsql
> <dnname></STRONG></P> <P>it throws an error " failed with some
> missing files".
Hmm - we need to find out why the files are missing. First thing to try is
"locate plpgsql.so" and see if that can find your library. If so, make sure
you have its location added to /etc/ld.so.conf and re-run "ldconfig".
If the file genuinely doesn't exist, did you install from RPM or source?
If RPM, try "rpm -ql postgresql-server" to see what files it thinks it
installed.
If source, can you remember what options you chose to compile with, or do you
have the source-directories still around? If you still have the source,
there'll be a file called configuration.cache or similar that should hold
your config options.
> so, i copied /<STRONG>usr/local/pgsql/plpgsql.so
> </STRONG>from Redhatlinux8.0 machine and tried again to create a language.
> this time i got an error like <STRONG>'Load of file
> /usr/lib/pgsql/plpgsql.so failed :/lib/i686/libc.so.6: version GLIB_2.3 not
> found (required by /usr/lib/pgsql/plpgsql.so).</STRONG></P>
RedHat changed their version of glibc between 7.2 and 8.0 - you can't just
move libraries between these versions.
--
Richard Huxton
Archonet Ltd
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, m_vijaykumar@hotmail.com
Subject: Re: createlang plpgsql failing on redhatlinux7.2
In-Reply-To: <200309121512.13546.dev@archonet.com>
* 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