From: Robert Treat <xzilla@users.sourceforge.net>
To: Richard Huxton <dev@archonet.com>
Cc: vijaykumar M <m_vijaykumar@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: createlang plpgsql failing on redhatlinux7.2
Date: 12 Sep 2003 11:49:13 -0400
Message-ID: <1063381753.2101.207.camel@camel> (raw)
In-Reply-To: <200309121512.13546.dev@archonet.com>
References: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
<200309121512.13546.dev@archonet.com>
rather do an rpm -qa | grep post to see if postgresql-pl-7.3.4-2PGDG is
installed, it is the rpm for procedural languages in 7.3.* and didn't
exist in the 7.2.* rpmset.
Robert Treat
On Fri, 2003-09-12 at 10:12, Richard Huxton wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
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: xzilla@users.sourceforge.net, dev@archonet.com, m_vijaykumar@hotmail.com
Subject: Re: createlang plpgsql failing on redhatlinux7.2
In-Reply-To: <1063381753.2101.207.camel@camel>
* 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