Re: [GENERAL] 回复： [GENERAL] Can't create plpython language

>
>
> [postgres(at)lix PostgreSQL]$ psql
> Password:
> psql (9.2.4)
> Type "help" for help.
>
> postgres=# create language plpython2u;
> ERROR: could not access file "$libdir/plpython2": No such file or
> directory
> postgres=# create language plpython3u;
> ERROR: could not access file "$libdir/plpython3": No such file or
> directory
> postgres=# \q
>
> There are python 2.4.3 and python3.2 on the same machine,.
>

I tried to create it using ActivePython3.2. It worked.

Stop the running postgresql cluster and set the ActivePython3.2 path as
below.

export PYTHONPATH=/opt/ActivePython-3.2/bin:$PATH
export PYTHONHOME=/opt/ActivePython-3.2/
export LD_LIBRARY_PATH=/opt/ActivePython-3.2/lib/

Now start the postgresql cluster and try creating the language;

-bash-4.1$ psql
psql.bin (9.2.3)
Type "help" for help.

postgres=# create language plpython3u;
CREATE LANGUAGE
postgres=#

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

> ------------------ 原始邮件 ------------------
> *发件人:* "Jov"<amutu(at)amutu(dot)com>;
> *发送时间:* 2013年7月5日(星期五) 上午7:59
> *收件人:* "Michael Paquier"<michael(dot)paquier(at)gmail(dot)com>; **
> *抄送:* ""<guxiaobo1982(at)qq(dot)com>; "pgsql-general"<
> pgsql-general(at)postgresql(dot)org>; **
> *主题:* Re: [GENERAL] Can't create plpython language
>
> try the postgresql official rpm package for centos 5：
>
> http://yum.postgresql.org/9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.noarch.rpm
>
> or build your own from source.
>
> Jov
> blog: http:amutu.com/blog <http://amutu.com/blog>
>
>
> 2013/7/5 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
>
>> On Thu, Jul 4, 2013 at 6:26 PM, guxiaobo1982 <guxiaobo1982(at)qq(dot)com> wrote:
>> > Hi,
>> >
>> > I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64
>> > server, I got the following errors when trying to create the python
>> language
>> > handler, can you help with this, thanks in advance.
>> If this is PPAS, as the version number would suggest, you should
>> directly ask this question to EDB support team. This problem might not
>> be related to Postgres itself... At least the buildfarm machines do
>> not crash when trying to install a plpython extension.
>> --
>> Michael
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>