I am using PostgreSQL 9.3 beta 2
[postgres@lix Multicorn-master]$ psql psql (9.3beta2) Type "help" for help. postgres=# It does not work with ActivePython3.2(ActivePython-3.2.2.3-linux-x86_64.tar.gz), Which version of PostgreSQL are you running? Regards, Xiaobo Gu ------------------ Original ------------------ Sender: "Raghavendra"<raghavendra....@enterprisedb.com>; Send time: Tuesday, Jul 9, 2013 8:00 PM To: "guxiaobo1982"<guxiaobo1...@qq.com>; Cc: "Jov"<am...@amutu.com>; "Michael Paquier"<michael.paqu...@gmail.com>; "pgsql-general"<pgsql-general@postgresql.org>; Subject: Re: [GENERAL] ?????? [GENERAL] Can't create plpython language [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 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