有什么食谱可以在Windows 64位上的Postgresql 9.3 64位或32位中成功安装PLPython吗? [英] Is there any recipe to successfully install PLPython in Postgresql 9.3 64bit or 32bit on Windows 64 bits?
问题描述
运行创建扩展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:
-
在C:\Python32中找到python3.dll \DLL(或任何安装它的位置)
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
这篇关于有什么食谱可以在Windows 64位上的Postgresql 9.3 64位或32位中成功安装PLPython吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!