From m_vijaykumar@hotmail.com Fri Sep 12 13:50:05 2003 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 45A47D1B4E5 for ; Fri, 12 Sep 2003 13:50:05 +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 82840-04 for ; Fri, 12 Sep 2003 10:49:36 -0300 (ADT) Received: from hotmail.com (bay2-f98.bay2.hotmail.com [65.54.247.98]) by svr1.postgresql.org (Postfix) with ESMTP id C5FBAD1B528 for ; Fri, 12 Sep 2003 10:49:32 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 12 Sep 2003 06:49:36 -0700 Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP; Fri, 12 Sep 2003 13:49:36 GMT X-Originating-IP: [202.63.107.19] X-Originating-Email: [m_vijaykumar@hotmail.com] From: "vijaykumar M" To: pgsql-sql@postgresql.org Subject: createlang plpgsql failing on redhatlinux7.2 Date: Fri, 12 Sep 2003 13:49:36 +0000 Mime-Version: 1.0 Content-Type: text/html Message-ID: X-OriginalArrivalTime: 12 Sep 2003 13:49:36.0776 (UTC) FILETIME=[B45D0080:01C37934] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_20_30 X-Spam-Level: X-Archive-Number: 200309/97 X-Sequence-Number: 15075



Hi All,
I'm getting some problem on "createlang plpgsql". with REDHATLINUX7.2

These are all my system configurations..

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 createlang plpgsql <dnname>

it throws an error " failed with some missing files". so, i copied /usr/local/pgsql/plpgsql.so from Redhatlinux8.0 machine and tried again to create a language. this time i got an error like '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).

Kindly guide to solve this issue. all ur helps are highly appreciable..

Thanks in advance,

Vijay

 

 

 

 


A chance to meet Aishwarya Rai. Win lucky prizes. From dev@archonet.com Fri Sep 12 14:12:47 2003 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 ; 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 ; 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 ; 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 To: "vijaykumar M" , 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: In-Reply-To: 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: >

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 createlang plpgsql > <dnname>

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 /usr/local/pgsql/plpgsql.so > from Redhatlinux8.0 machine and tried again to create a language. > this time i got an error like '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).

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 From xzilla@users.sourceforge.net Fri Sep 12 15:50:25 2003 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 ; 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 ; 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 ; 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 To: Richard Huxton Cc: vijaykumar M , pgsql-sql@postgresql.org In-Reply-To: <200309121512.13546.dev@archonet.com> References: <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: > >

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 createlang plpgsql > > <dnname>

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 /usr/local/pgsql/plpgsql.so > > from Redhatlinux8.0 machine and tried again to create a language. > > this time i got an error like '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).

> > 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 From dev@archonet.com Fri Sep 12 16:18:52 2003 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 3A2CDD1B4F6 for ; Fri, 12 Sep 2003 16:18:52 +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 07066-05 for ; Fri, 12 Sep 2003 13:18:42 -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 718DCD1B4E8 for ; Fri, 12 Sep 2003 13:18:41 -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 19xqd6-0005ND-0Z; Fri, 12 Sep 2003 17:18:41 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 28196162DC; Fri, 12 Sep 2003 17:18:40 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 7495B16296; Fri, 12 Sep 2003 17:18:39 +0100 (BST) From: Richard Huxton To: Robert Treat Subject: Re: createlang plpgsql failing on redhatlinux7.2 Date: Fri, 12 Sep 2003 17:18:39 +0100 User-Agent: KMail/1.5 Cc: vijaykumar M , pgsql-sql@postgresql.org References: <200309121512.13546.dev@archonet.com> <1063381753.2101.207.camel@camel> In-Reply-To: <1063381753.2101.207.camel@camel> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309121718.39078.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/101 X-Sequence-Number: 15079 On Friday 12 September 2003 16:49, Robert Treat wrote: > 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. Ah, but the .so isn't in the -pl RPM (I'm guessing plpgsql is considered "core"). $ rpm -qif /usr/lib/pgsql/plpgsql.so Name : postgresql-server Relocations: (not relocateable) Version : 7.3.4 Vendor: (none) ... -- Richard Huxton Archonet Ltd From xzilla@users.sourceforge.net Sat Sep 13 23:45:24 2003 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 2C33CD1B4FE for ; Sat, 13 Sep 2003 23:45:24 +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 05252-10 for ; Sat, 13 Sep 2003 20:44:56 -0300 (ADT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id 14266D1B4F0 for ; Sat, 13 Sep 2003 20:44:53 -0300 (ADT) Received: from [192.168.0.10] ([68.101.69.37]) by lakemtao04.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20030913234457.LAXO29227.lakemtao04.cox.net@[192.168.0.10]>; Sat, 13 Sep 2003 19:44:57 -0400 From: Robert Treat To: Richard Huxton Subject: Re: createlang plpgsql failing on redhatlinux7.2 Date: Sat, 13 Sep 2003 19:44:55 -0400 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <1063381753.2101.207.camel@camel> <200309121718.39078.dev@archonet.com> In-Reply-To: <200309121718.39078.dev@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309131944.55180.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/112 X-Sequence-Number: 15090 On Friday 12 September 2003 12:18, Richard Huxton wrote: > On Friday 12 September 2003 16:49, Robert Treat wrote: > > 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. > > Ah, but the .so isn't in the -pl RPM (I'm guessing plpgsql is considered > "core"). > > $ rpm -qif /usr/lib/pgsql/plpgsql.so > Name : postgresql-server Relocations: (not relocateable) > Version : 7.3.4 Vendor: (none) > ... Right you are Richard, my apologies. I'll go crawl back under my rock now :-) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL