X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8CD4CD1B52F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Sep 2003 15:50:25 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 08051-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Sep 2003 12:49:53 -0300 (ADT)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by svr1.postgresql.org (Postfix) with ESMTP id 5FD71D1B533
	for <pgsql-sql@postgresql.org>; Fri, 12 Sep 2003 12:49:53 -0300 (ADT)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h8CEdQqd002807;
	Fri, 12 Sep 2003 10:39:26 -0400
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h8CFnDZ11501;
	Fri, 12 Sep 2003 11:49:13 -0400
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id Q65SL2HZ; Fri, 12 Sep 2003 11:49:11 -0400
Subject: Re: createlang plpgsql failing on redhatlinux7.2
From: Robert Treat <xzilla@users.sourceforge.net>
To: Richard Huxton <dev@archonet.com>
Cc: vijaykumar M <m_vijaykumar@hotmail.com>, pgsql-sql@postgresql.org
In-Reply-To: <200309121512.13546.dev@archonet.com>
References: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
	<200309121512.13546.dev@archonet.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 12 Sep 2003 11:49:13 -0400
Message-Id: <1063381753.2101.207.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/100
X-Sequence-Number: 15078

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 &nbsp;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
> > &lt;dnname&gt;</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