有什么食谱可以在Windows 64位上的Postgresql 9.3 64位或32位中成功安装PLPython吗?

问题描述:

运行创建扩展plpython3u 给我错误-找不到指定的模块,即使文件为在正确的位置。

running CREATE EXTENSION plpython3u gave me the error - The specified module could not be found even if the file is at the correct place.

在阅读完网络上的所有内容后,我尝试按照建议的方式下载另一个python版本(3.2),并替换了 dll

After reading everything on the web, I tried to download another python version (3.2) as suggested and replace the dll.

现在,我收到有关丢失的魔术块的错误:丢失的魔术块提示:需要扩展库才能使用PG_MODULE_MAGIC宏。

Now I receive an error about a missing magic block: missing magic block HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.

我尝试使用32位和64位版本的Postgresql进行相同的处理,但都失败,就像解释的那样。

I tried the same processes with a 32 and 64 bits version of Postgresql and both failed like explained.

在Windows 64位操作系统上安装PLPython的任何解决方案?

Is there any solution to install that PLPython on a Windows 64 bits OS?

为我工作(Windows 7 64位)

Worked for me (Windows 7 64-bit)

我从这里安装了Python 3.2:

I installed Python 3.2 from here:

http://www.python.org/ftp/python/3.2/python-3.2.amd64.msi

有人搞砸了,所以您需要执行以下操作:

Somebody screwed something up, so you need to do the following:


  1. 在C:\Python32中找到python3.dll \DLL(或任何安装它的位置)

  1. find python3.dll in C:\Python32\DLLs (or wherever you installed it)

将python3.dll复制到python32.dll(例如复制并粘贴然后重命名)

copy python3.dll to python32.dll (like copy and paste it then rename it)

在postgres中运行创建扩展名plpython3u

run create extension plpython3u in postgres