让plperl在OSX的9.3上工作

Question

我正在尝试在我从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函数实现(它使用一些更高级的格式化选项)，但我离题了。

Answer 1

要安装plperl，您必须安装plperl 5.14，该版本不高于或低于该版本。Activestate让这件事变得很困难，因为他们已经改变了所有的许可，现在你必须为访问这个旧版本付费(这是postgres可以免费使用的最后一个版本)。幸运的是，即使他们已经从他们的下载网站上删除了5.14，CNET仍然可以使用。可在此处下载：

ActivePerl 5.14 OSX /x86