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 027B0D1B527
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Sep 2003 14:12:47 +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 90280-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Sep 2003 11:12:16 -0300 (ADT)
Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net
	[194.217.242.85])
	by svr1.postgresql.org (Postfix) with ESMTP id A485AD1B4E5
	for <pgsql-sql@postgresql.org>; Fri, 12 Sep 2003 11:12:12 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1)
	id 19xoem-0008PS-0Z; Fri, 12 Sep 2003 15:12:16 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id D700915A87; Fri, 12 Sep 2003 15:12:15 +0100 (BST)
Received: from client17.archonet.com (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 05C7A15960; Fri, 12 Sep 2003 15:12:14 +0100 (BST)
From: Richard Huxton <dev@archonet.com>
To: "vijaykumar M" <m_vijaykumar@hotmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: createlang plpgsql failing on redhatlinux7.2
Date: Fri, 12 Sep 2003 15:12:13 +0100
User-Agent: KMail/1.5
References: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
In-Reply-To: <BAY2-F98CgxdvzhTLSm00007614@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200309121512.13546.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/99
X-Sequence-Number: 15077

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