编译 postgresql --with -python

概述createlang plpythonu postgres; createlang:    "$libdir/plpython2": No su ch file or directory CREATE LANGUAGE plpythonu;  create language 'plpythonu'; select version(); select tmplname, tmplhandler, t
createlang plpythonu postgres;
createlang: "$libdir/plpython2": No su
ch file or directory


CREATE LANGUAGE plpythonu;
create language 'plpythonu';


select version();


select tmplname,tmplhandler,tmpllibrary from pg_pltemplate where tmplname like 'plpython%'




CREATE LANGUAGE "plpython3u"


SELECT * FROM pg_available_extensions WHERE name liKE '%python%' ORDER BY name;
CREATE EXTENSION plpython3u FROM unpackaged;


CREATE EXTENSION plpython2u FROM unpackaged;


CREATE EXTENSION plpython3u;
CREATE EXTENSION plpythonu;


CREATE PROCEDURAL LANGUAGE plpythonu;


CREATE OR REPLACE FUNCTION iseven(integer)
RETURNS BOolEAN AS
$BODY$
t = args[0]
return t%2 == 0
$BODY$
LANGUAGE 'plpython3u' VolATILE


select iseven(3);
3.编译postgresql_9.2.4,原先是9.1.3 [postgres@kenyon ~] $tar -zxvf postgresql_9.2.4.tar.gz [postgres@kenyon ~] cd postgresql_9.2.4 [postgres@kenyon postgresql_9.2.4]./configure --prefix=/home/postgres --with-pgport=5432 --with-segsize=8 --with-wal-segsize=64 --with-wal-blocksize=64 --with-perl --with-python --with-openssl --with-pam --with-ldap --with-libxml --with-libxslt --enable-thread-safety [postgres@kenyon postgresql_9.2.4]gmake world [postgres@kenyon postgresql_9.2.4]gmake install-world 如果顺利的话，这个时候可以看一下BIN是否已经换成9.2.4 [postgres@kenyon postgresql_9.2.4]$ psql -V psql (Postgresql) 9.2.4 [postgres@kenyon postgresql_9.2.4]$ 说明BIN文件等已经OK 如果原始版本是9.2.0及以上，可忽略以下步骤，直接启动postgres,如果是9.2.0以下版本,直接启动会报错，则继续,类似initdb与configure版本不一致的问题 总结

以上是内存溢出为你收集整理的编译 postgresql --with -python全部内容，希望文章能够帮你解决编译 postgresql --with -python所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。