在 Windows 上安装 PG Gem 时出错

编程入门行业动态更新时间:2024-10-28 02:30:28

本文介绍了在 Windows 上安装 PG Gem 时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

我使用 XAMPP 作为 PostgreSQL 9.3 的安装文件夹.

I'm using XAMPP as my installation folder for PostgreSQL 9.3.

C:\xampp\pgsql\9.3

现在我正在尝试使用该目录作为参考安装 PostgreSQL gem:

And now I'm trying to install PostgreSQL gem using that directory as a reference:

gem install pg -- --with-pg-include="C:\xampp\pgsql\9.3\include" --with-pg-lib="C:\xampp\pgsql\9.3\lib" --with-pg-config="C:\xampp\pgsql\9.3\bin\pg_config"

但是这个命令失败了，错误如下:

But this command failed with errors listed below:

ERROR: Error installing pg: ERROR: Failed to build gem native extension. C:/Ruby/Ruby200/bin/ruby.exe extconf.rb --with-pg-include=C:\xampp\pgsql\9.3 \include --with-pg-lib=C:\xampp\pgsql\9.3\lib --with-pg-config=C:\xampp\pgsql\9. 3\bin\pg_config Using config values from C:\xampp\pgsql\9.3\bin\pg_config checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for pg_config_manual.h... yes checking for PQconnectdb() in -lpq... no checking for PQconnectdb() in -llibpq... no checking for PQconnectdb() in -lms/libpq... no Cant find the PostgreSQL client library (libpq) *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=C:/Ruby/Ruby200/bin/ruby --with-pg --without-pg --with-pg-config --with-pg-dir --without-pg-dir --with-pg-include=${pg-dir}/include --with-pg-lib=${pg-dir}/ --with-pqlib --without-pqlib --with-libpqlib --without-libpqlib --with-ms/libpqlib --without-ms/libpqlib extconf failed, exit code 1 Gem files will remain installed in C:/Ruby/Ruby200/lib/ruby/gems/2.0.0/gems/pg-0 .17.1 for inspection. Results logged to C:/Ruby/Ruby200/lib/ruby/gems/2.0.0/extensions/x86-mingw32/2.0 .0/pg-0.17.1/gem_make.out

我在pgsql里面查看的时候，里面居然有一个名为libpq.dll的文件

When I checked inside pgsql, there was actually a file named libpq.dll inside of

C:\xampp\pgsql\9.3\lib

那为什么报错说找不到PostgreSQL客户端库(libpq)??有没有针对此错误的解决方案?仅供参考，我正在使用:

So why did the error say it couldn't find the PostgreSQL client library (libpq)?? Is there any solutions for this error? FYI, I'm using: