PostgreSQL 8.3.1中的pg

本文介绍了PostgreSQL 8.3.1中的pg_config的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试从源代码构建Postgresql 8.3.1（后来我需要在其顶部运行扩展补丁）。不过， src / tutorial 不会使

I'm trying to build Postgresql 8.3.1 from sources (later I need to run extension patch on the top of it). Nevertheless, the src/tutorial doesn't make

$make make: pg_config: Command not found make: *** No targets. Stop.

我去了的 bin 目录安装后，我发现 pg_config.exe 在那里，我需要帮助以使配置检测到它。

I went to the bin directory of the installation and I found pg_config.exe there, I need help to make the configuration detect it.

我尝试了一些方法像：

./configure --with-pg-config=path/pgsql/bin make make install

但它仍然无法正常工作。

but it's still not working.

谢谢

推荐答案

您需要确保 pg_config 在可执行搜索路径上- PATH 环境变量中-在运行 configure 之前。

You need to make sure that pg_config is on the executable search path - the PATH environment variable - before running configure.

似乎您可能正在将MinGW与msys一起使用，在这种情况下，您可以使用Andrew建议的语法。根据文档，PostgreSQL可执行文件的位置在msys上可能有些奇怪。 UNIX路径中包含冒号，因此它们不能包含诸如 c：\ 这样的驱动器说明符，因此MinGW将驱动器号装载为根目录条目，例如 / c 。因此，对于 c：\Program Files\PostgreSQL 8.3\bin ，您将使用：

It appears that you're probably using MinGW with msys, in which case you can use the syntax Andrew proposed. The location of the PostgreSQL executables may be a bit odd on msys, though, as per the documentation. UNIX paths have colons in them, so they can't contain drive specifiers like c:\, so MinGW "mounts" the drive letters as root directory entries like /c. Thus, for c:\Program Files\PostgreSQL 8.3\bin you would use:

"/c/Program Files/PostgreSQL 8.3/bin/pg_config.exe"

<请注意双引号。尝试在msys中将其作为命令运行，看看会发生什么。如果您得到的 pg_config 输出不是错误，则使用以下命令将其添加到 PATH 中：

Note the double quotes. Try running that as a command in msys, see what happens. If you got pg_config output not an error, add it to the PATH with:

export PATH="$PATH:/c/Program Files/PostgreSQL 8.3/bin"

如果您使用Cygwin，则：

If you're on Cygwin, then:

• 那不是真的理想的环境，是半开窗，半开放的空间。考虑使用MinGW + msys，或按照在Windows上从源代码安装。

Cygwin也可以安装 C：\ 为 / c / ，因此上述路径对Cygwin同样有效。

Cygwin also mounts C:\ as /c/ so the path above should be just as valid for Cygwin.

如果您明确提到，这会容易得多：

This would've been a lot easier if you'd mentioned clearly:

• 您的运营系统
• 您的编译器和工具集

此外，a_horse_with_no_name是非常正确的：安装PostgreSQL 8.3。现在只有1个。绝对最低限度您应该安装8.3.21，即撰写本文时8.3系列的当前版本。根据版本政策，该版本与所有8.3.x版本完全兼容。然后，您应该开始紧急准备工作，以在8.3寿命终止之前更新到9.2（如果您坚持则为9.1）。再次，请参阅版本政策。

Additionally, a_horse_with_no_name is quite right: Installing PostgreSQL 8.3.1 now is just nuts. At the absolute bare minimum you should be installing 8.3.21, the current version of the 8.3 series at time of writing. As per the version policy this is completely compatible with all 8.3.x versions. You should then begin urgent preparations to update to 9.2 (or 9.1 if you insist) before 8.3 goes end-of-life; again, see the version policy.