在 Windows 上安装 plpythonu [英] Installing plpythonu on Windows

问题描述

我正在尝试在 Windows 机器上的 postgres 服务器上安装 plpython.当我在 postgres 中发出命令 CREATE EXTENSION plpython3u; 时，出现以下错误，我正在尝试查找其来源.

I'm trying to install plpython on a postgres server on a Windows machine. When I issue the command CREATE EXTENSION plpython3u; in postgres, I get the following error, which I'm trying to find the source of.

ERROR: could not load library "C:/Program Files/PostgreSQL/9.3/lib/plpython3.dll": The specified module could not be found.

此文件存在，我认为这意味着 Windows 找不到它所依赖的文件之一.当我使用 Dependency Walker 打开 plpython3.dll 时，它告诉我它无法找到 GPSVC.dll.

This file exists, which I presume means that Windows can't find one of the files it depends on. When I open the plpython3.dll with Dependency Walker, it tells me it can't locate the GPSVC.dll.

这个缺失的 dll 是否会导致 CREATE EXTENSION 命令失败?我在 C:\Windows\System32 中找到了一个同名的 .dll 并将其复制到 C:\Windows\SysWOW64，但这并没有解决问题，虽然依赖步行者现在找到了 .dll，但它引发了其他几个具有不同 CPU 类型的模块的错误.

Is it likely that this missing dll would cause the CREATE EXTENSION command to fail? I found a .dll with the same name in C:\Windows\System32 and copied it over to C:\Windows\SysWOW64, but this did not resolve the probelm, and although dependency walker now finds the .dll, it raises several other errors about having modules with different CPU types.

推荐答案

在 Windows 上使用特定的 python 版本.我可以在 python 3.2.x 和 postgres 9.3 上运行它

Use specific python version on Windows. I could get it running with python 3.2.x with postgres 9.3

这篇关于在 Windows 上安装 plpythonu的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！