> > > [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 Blog: http://raghavt.blogspot.com/ > ------------------ 原始邮件 ------------------ > *发件人:* "Jov"<am...@amutu.com>; > *发送时间:* 2013年7月5日(星期五) 上午7:59 > *收件人:* "Michael Paquier"<michael.paqu...@gmail.com>; ** > *抄送:* ""<guxiaobo1...@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. > > Jov > blog: http:amutu.com/blog <http://amutu.com/blog> > > > 2013/7/5 Michael Paquier <michael.paqu...@gmail.com> > >> On Thu, Jul 4, 2013 at 6:26 PM, guxiaobo1982 <guxiaobo1...@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 >> > >
