pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcreatelang plpgsql failing on redhatlinux7.2
5+ messages / 3 participants
[nested] [flat]
* createlang plpgsql failing on redhatlinux7.2
@ 2003-09-12 13:49 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: vijaykumar M @ 2003-09-12 13:49 UTC (permalink / raw)
To: pgsql-sql
<html><div style='background-color:'><DIV>
<P><BR><BR></P>Hi All, </DIV>I'm getting some problem on "<STRONG>createlang plpgsql</STRONG>". with REDHATLINUX7.2
<DIV></DIV>
<P>These are all my system configurations..</P>
<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". 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>
<P><STRONG>Kindly guide to solve this issue. all ur helps are highly appreciable..</STRONG></P>
<P>Thanks in advance,</P>
<P>Vijay</P>
<P><STRONG></STRONG> </P>
<P><STRONG></STRONG> </P>
<P> </P>
<P> </P></div><br clear=all><hr>A chance to meet Aishwarya Rai. <a href="http://g.msn.com/8HMFENIN/2746??PS=">Win lucky prizes.</a> </html>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createlang plpgsql failing on redhatlinux7.2
@ 2003-09-12 14:12 Richard Huxton <dev@archonet.com>
parent: vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Richard Huxton @ 2003-09-12 14:12 UTC (permalink / raw)
To: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createlang plpgsql failing on redhatlinux7.2
@ 2003-09-12 15:49 Robert Treat <xzilla@users.sourceforge.net>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 5+ messages in thread
From: Robert Treat @ 2003-09-12 15:49 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createlang plpgsql failing on redhatlinux7.2
@ 2003-09-12 16:18 Richard Huxton <dev@archonet.com>
parent: Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 5+ messages in thread
From: Richard Huxton @ 2003-09-12 16:18 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: createlang plpgsql failing on redhatlinux7.2
@ 2003-09-13 23:44 Robert Treat <xzilla@users.sourceforge.net>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 5+ messages in thread
From: Robert Treat @ 2003-09-13 23:44 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-09-13 23:44 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-12 13:49 createlang plpgsql failing on redhatlinux7.2 vijaykumar M <m_vijaykumar@hotmail.com>
2003-09-12 14:12 ` Richard Huxton <dev@archonet.com>
2003-09-12 15:49 ` Robert Treat <xzilla@users.sourceforge.net>
2003-09-12 16:18 ` Richard Huxton <dev@archonet.com>
2003-09-13 23:44 ` Robert Treat <xzilla@users.sourceforge.net>
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