Skip site navigation (1) Skip section navigation (2)

Re: problems loading languages

From: Mija Lee <mija(at)scharp(dot)org>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problems loading languages
Date: 2007-09-11 19:18:43
Message-ID: 200709111918.l8BJIgka010555@brood2.pc.scharp.org (view raw or flat)
Thread:
Lists: pgsql-novice
Tom:

you are right. I was looking at another install of pg 8.1 which used the solaris 
packages. So as it turns out the solaris-package 8.1 was pointing to /usr/lib 
and my new 8.2 is pointing to /systems/pg8.2/lib, and the plperl did not exist 
in the second directory.

Thank you so much for your help!

Mija


>X-Spam-Level: 
>X-Spam-Status: No, score=0.5 required=5.0 tests=AWL,URI_NOVOWEL autolearn=no  
version=3.1.3
>X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
>To: Mija Lee <mija(at)scharp(dot)org>
>cc: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] problems loading languages 
>Comments: In-reply-to Mija Lee <mija(at)scharp(dot)org> message dated "Tue, 11 Sep 
2007 08:55:12 -0700"
>Date: Tue, 11 Sep 2007 14:40:19 -0400
>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>X-Virus-Scanned: Maia Mailguard 1.0.1
>List-Archive: <http://archives.postgresql.org/pgsql-novice>
>List-Help: <mailto:majordomo(at)postgresql(dot)org?body=help>
>List-ID: <pgsql-novice.postgresql.org>
>List-Owner: <mailto:pgsql-novice-owner(at)postgresql(dot)org>
>List-Post: <mailto:pgsql-novice(at)postgresql(dot)org>
>List-Subscribe: <mailto:majordomo(at)postgresql(dot)org?body=sub%20pgsql-novice>
>List-Unsubscribe: <mailto:majordomo(at)postgresql(dot)org?body=unsub%20pgsql-novice>
>
>Mija Lee <mija(at)scharp(dot)org> writes:
>> - pg has been configured --with perl
>> - the libdir is /usr/lib
>> - there are plpgsql.so and plperl.so in the libdir
>> - I get this:
>
>> postgres=# create language plperl;
>> ERROR:  could not access file "$libdir/plperl": No such file or directory
>
>I rather doubt that libdir is /usr/lib.  It's much more likely to have
>"postgres" or "postgresql" in the path somewhere.  "pg_config --pkglibdir"
>would tell you for sure.
>
>			regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings


pgsql-novice by date

Next:From: Wright, GeorgeDate: 2007-09-12 12:51:01
Subject: Passing column name to a function at runtime
Previous:From: Tom LaneDate: 2007-09-11 18:40:19
Subject: Re: problems loading languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group