Rails 3 - can't install pg gem

D

16

100

When I try to run bundle (bundle install), I all the time get

Installing pg (0.13.2) with native extensions 
Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

        /Users/ryan/.rvm/rubies/ruby-1.9.2-p290/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=/Users/ryan/.rvm/rubies/ruby-1.9.2-p290/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 /Users/ryan/.rvm/gems/ruby-1.9.2-p290/gems/pg-0.13.2 for inspection.
Results logged to /Users/ryan/.rvm/gems/ruby-1.9.2-p290/gems/pg-0.13.2/ext/gem_make.out
An error occured while installing pg (0.13.2), and Bundler cannot continue.
Make sure that `gem install pg -v '0.13.2'` succeeds before bundling.

I use Mac OS X 10.6, the version of installed PostgreSQL is 9.1. I found the problem is in the libpq-dev, how could I install/fix that?

Demasculinize answered 12/3, 2012 at 14:17 Comment(5)

how have you install postgres on your mac ? – Immoderation 12/3, 2012 at 14:25

this way – Demasculinize 12/3, 2012 at 14:29

on_click installer ? Flink ? or MacPort ? – Immoderation 12/3, 2012 at 14:36

I tried to install that by this way: sudo port install libpq-dev, but another problem - Error: Port libpq-dev not found To report a bug, see <http://guide.macports.org/#project.tickets>. That's terrible, still some problems... – Demasculinize 12/3, 2012 at 15:14

See this question: [here][1] [1]: #10321689 – Welcher 25/4, 2012 at 19:53

M

78

As stated in your error log you need to pass in the path to the pg_config. Try to install the gem using:

gem install pg -- --with-pg-config= 'PATH_TO_YOUR_PG_CONFIG'

If you are not sure where your pg_config is, and assuming you are on Linux or Mac, you can run the following command:

which pg_config

Your pg-config can be in different locations depending on how you installed postgres.

Mallorca answered 12/3, 2012 at 15:3 Comment(9)

As a note, the binary package from the Postgres site does not contain development headers or the pg_config program. – Jeanne 12/3, 2012 at 15:43

The binary package from here: enterprisedb.com/products-services-training/pgdownload#osx most certainly does contain both pg_config (e.g., at /Library/PostgreSQL/9.1/bin/pg_config for 9.1.x) and the development headers. It's what I use to test the pg gem in development. – Insolvable 12/3, 2012 at 23:53

Wouldn't which pg_config be faster than find / -name pg_config? – Gorski 3/11, 2012 at 20:27

Made a minor tweak to your command line args. Replacing the version with your current one should work ok. Here's my command line: sudo env ARCHFLAGS="-arch x86_64" gem install pg -- --with-pg-include=/Library/PostgreSQL/9.1/include/ --with-pg-lib=/Library/PostgreSQL/9.1/lib/ – Frigorific 29/11, 2013 at 20:46

On OSX you may also use brew to get the headers via brew install libpqxx and everything will go fine. – Sporran 13/12, 2013 at 18:59

For some reason which did not find the location of the pg_config file. for me it was located at /Library/PostgreSQL/9.1/bin/pg_config. just in case this may help someone else – Entryway 29/12, 2013 at 20:23

Mine was gem install pg -- --with-pg-config=/Library/PostgreSQL/9.2/bin/pg_config – Luminescent 2/1, 2014 at 21:17

If you're using the POSTGRES app from Heroku, the pg_config is located at /Applications/Postgres.app/Contents/MacOS/bin/pg_config – Cantle 23/1, 2014 at 21:48

You can change this to: gem install pg -- --with-pg-config=`which pg_config` – Emplane 28/4, 2015 at 3:28

F

100

if you are running on Linux you may be interested in what worked for me:

sudo apt-get install postgresql
sudo apt-get install libpq-dev

Then

gem install pg

then

bundle install

src: http://wikimatze.de/installing-postgresql-gem-under-ubuntu-and-mac

Felt answered 29/5, 2012 at 1:24 Comment(6)

thank, as it's in my case - no need to run bundle gem install pg – Kamalakamaria 10/6, 2012 at 15:48

Worked for me as of November 2013 running Ubuntu 13.04! – Ego 5/11, 2013 at 14:3

why does this have so many upvotes when it's clearly for the wrong OS? – Dede 2/12, 2013 at 7:5

@Dede it clearly states the OS it should be used on. And clearly a lot of people with Linux OSes are finding this answer when they research this problem. – Felt 2/12, 2013 at 7:11

This should work if you use the repositories. Obviously it won't work if you compile from source. But it worked beautifully on Ubuntu 14.04 when using the repositories. – Atterbury 23/5, 2015 at 20:46

That made it work. Key point being that postgresql needs to be installed on your machine. – Nels 13/11, 2015 at 19:31

M

78

As stated in your error log you need to pass in the path to the pg_config. Try to install the gem using:

gem install pg -- --with-pg-config= 'PATH_TO_YOUR_PG_CONFIG'

If you are not sure where your pg_config is, and assuming you are on Linux or Mac, you can run the following command:

which pg_config