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

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: [GENERAL] 回复: [GENERAL] Can't create plpython language
Дата
Msg-id CA+h6Ahjgc4qT5obhDDEDRWX3g=_T_w44cLE6+NZOYbzH41nJ8Q@mail.gmail.com
обсуждение исходный текст
Ответ на =?gb18030?B?u9i4tKO6IFtHRU5FUkFMXSBDYW4ndCBjcmVhdGUg?= =?gb18030?B?cGxweXRob24gbGFuZ3VhZ2U=?=  ("guxiaobo1982" <guxiaobo1982@qq.com>)
Список pgsql-general

[postgres@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

 
------------------ 原始邮件 ------------------
发件人: "Jov"<amutu@amutu.com>;
发送时间: 2013年7月5日(星期五) 上午7:59
收件人: "Michael Paquier"<michael.paquier@gmail.com>;
抄送: ""<guxiaobo1982@qq.com>; "pgsql-general"<pgsql-general@postgresql.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.



2013/7/5 Michael Paquier <michael.paquier@gmail.com>
On Thu, Jul 4, 2013 at 6:26 PM, guxiaobo1982 <guxiaobo1982@qq.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


В списке pgsql-general по дате отправления:

Предыдущее
От: "Adrian.Vondendriesch"
Дата:
Сообщение: Re: My question about autonomous transaction
Следующее
От: Peter Kroon
Дата:
Сообщение: pg 9.2.4 dblink