我使用的是Ruby on Rails 3.1预版本。我喜欢使用PostgreSQL,但问题是安装pg gem。它给了我以下错误:

$ gem install pg
Building native extensions.  This could take a while...
ERROR:  Error installing pg:
    ERROR: Failed to build gem native extension.

        /home/u/.rvm/rubies/ruby-1.9.2-p0/bin/ruby extconf.rb
checking for pg_config... no
No pg_config... trying anyway. If building fails, please try again with
 --with-pg-config=/path/to/pg_config
checking for libpq-fe.h... no
Can't find the 'libpq-fe.h header
*** 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=/home/u/.rvm/rubies/ruby-1.9.2-p0/bin/ruby
    --with-pg
    --without-pg
    --with-pg-dir
    --without-pg-dir
    --with-pg-include
    --without-pg-include=${pg-dir}/include
    --with-pg-lib
    --without-pg-lib=${pg-dir}/lib
    --with-pg-config
    --without-pg-config
    --with-pg_config
    --without-pg_config
    Gem files will remain installed in /home/u/.rvm/gems/ruby-1.9.2-p0/gems/pg-0.11.0 for inspection.
    Results logged to /home/u/.rvm/gems/ruby-1.9.2-p0/gems/pg-0.11.0/ext/gem_make.out

我怎么解决这个问题?


当前回答

在Ubuntu 20.04上,我已经有libpq5:amd64 version 13.2-1.pgdg20.04+1。现在,当我试图从apt存储库安装libpq-dev时,我正在接收

The following packages have unmet dependencies:
libpq-dev : Depends: libpq5 (= 12.6-0ubuntu0.20.04.1) but 13.2-1.pgdg20.04+1 is to be installed

我从http://ftp.us.debian.org/debian/pool/main/p/postgresql-13/libpq-dev_13.2-1_amd64.deb上获取了deb,并做了以下工作:

mkdir -p /tmp/libpq-dev
dpkg-deb -R libpq-dev_13.2-1_amd64.deb /tmp/libpq-dev
sed -i 's|= 13.2-1|= 13.2-1.pgdg20.04+1|' /tmp/libpq-dev/DEBIAN/control
dpkg-deb -b /tmp/libpq-dev /tmp/libpq-dev-new.deb
sudo dpkg -i /tmp/libpq-dev-new.deb

从那以后,我一直在愉快地使用宝石。没有额外的安装或任何东西。

其他回答

在FreeBSD(9.1)上,必要的包是/usr/ports/database/postgresql-server*,安装时也会安装所需的头文件,使gem安装“pg”失败。这里的答案帮助我找到解决方案,但包名的差异需要进行一些搜索。

希望这能帮助人们在FreeBSD系统上搜索“-dev”包时避免一点挠头!

libpq-fe.h的位置取决于PostgreSQL的安装位置(这取决于你如何安装它)。使用locate (http://en.wikipedia.org/wiki/Locate_%28Unix%29)在您的机器上查找libpq-fe.h文件。如果它存在,它将在PostgreSQL安装的include目录中。

$ locate libpq-fe.h
/Library/PostgreSQL/9.1/include/libpq-fe.h

包含pg_config的bin目录将位于与include目录相同的目录中。正如错误提示的那样,使用——with-pg-config选项来安装gem:

$ gem install pg --with-pg-config="/Library/PostgreSQL/9.1/bin/pg_config"

注意,如果你从未使用过locate,或者自从安装PostgreSQL后就没有更新过,你可能需要运行updatedb。

对于AltLinux,是postgresqlx包。X-devel(在我的例子中是postgresql9.5-devel)必须安装:

apt-get install postgresql9.5-devel

Mac用户使用Postgres的正确答案。应用程序是根据该包提供的libpq构建的。例如,对于9.4版本(撰写本文时的最新版本),您所需要的是:

export CONFIGURE_ARGS="with-pg-include=/Applications/Postgres.app/Contents/Versions/9.4/include"
gem install pg

这将使你的pg gem与你安装的PostgreSQL版本保持同步。在这种情况下,安装Homebrew软件是一种浪费。

看起来在Ubuntu中,头文件是libpq-dev包的一部分(至少在以下Ubuntu版本中是这样的: 11.04 (Natty Narwhal), 10.04 (Lucid Lynx), 11.10 (Oneiric Ocelot), 12.04 (Precise穿山甲),14.04 (Trusty Tahr)和18.04(仿生海狸)):

...
/usr/include/postgresql/libpq-fe.h
...

所以试着为你的操作系统安装libpq-dev或类似的软件:

Ubuntu/Debian系统:sudo apt-get install libpq-dev RHEL系统:yum install postgresql-devel 对于Mac Homebrew: brew安装postgresql 对于Mac MacPorts PostgreSQL: gem install pg -- --with-pg-config=/opt/local/lib/ PostgreSQL[版本号]/bin/pg_config . exe OpenSuse:在postgresql-devel中使用zypper 对于ArchLinux: pacman -S postgresql-libs