我正在尝试在我从OSX Mavericks上的Enterprise DB下载的Postgres 9.3包上安装plperl。--每次我发出
create language plperl我得到了
postgres-# ;
The connection to the server was lost. Attempting reset: Failed.
!>编辑:日志文件显示
2014-01-02 14:08:50 CST LOG: server process (PID 4843) was terminated by signal 11: Segmentation fault
2014-01-02 14:08:50 CST DETAIL: Failed process was running: CREATE EXTENSION IF NOT EXISTS plperl WITH SCHEMA pg_catalog;
2014-01-02 14:08:50 CST LOG: terminating any other active server processes
2014-01-02 14:08:50 CST WARNING: terminating connection because of crash of another server process
2014-01-02 14:08:50 CST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2014-01-02 14:08:50 CST HINT: In a moment you should be able to reconnect to the database and repeat your command.
2014-01-02 14:08:50 CST WARNING: terminating connection because of crash of another server process
2014-01-02 14:08:50 CST DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2014-01-02 14:08:50 CST HINT: In a moment you should be able to reconnect to the database and repeat your command.我依稀可见地记得在9.2上安装它时不得不摆弄activeperl库,但我想也许这里有人知道在OSX上安装并运行plperl的最好方法。
这很可悲,但我真的不需要plperl,除了perl有最好的sprintf函数实现(它使用一些更高级的格式化选项),但我离题了。
发布于 2014-01-03 05:14:08
要安装plperl,您必须安装plperl 5.14,该版本不高于或低于该版本。Activestate让这件事变得很困难,因为他们已经改变了所有的许可,现在你必须为访问这个旧版本付费(这是postgres可以免费使用的最后一个版本)。幸运的是,即使他们已经从他们的下载网站上删除了5.14,CNET仍然可以使用。可在此处下载:
ActivePerl 5.14 OSX /x86
https://stackoverflow.com/questions/20891309
复制相似问题