Rails 3 - can't install pg gem

Question

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?

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 `. That's terrible, still some problems... — user984621, Mar 12 '12 at 15:14
See this question: [here][1] [1]: http://stackoverflow.com/questions/10321189/teaching-myself-rails-deploying-first-app-to-heroku-failure-to-upload-sqlite3 — banditKing, Apr 25 '12 at 19:53

score 100 · Answer 1 · edited Feb 10 '13 at 23:22

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

edited Feb 10 '13 at 23:22

ogoldberg

781
7
8

answered May 29 '12 at 01:24

E.E.33

2,013
3
22
34

1

thank, as it's in my case - no need to run bundle gem install pg – valk Jun 10 '12 at 15:48
1

Worked for me as of November 2013 running Ubuntu 13.04! – Starkers Nov 05 '13 at 14:03
why does this have so many upvotes when it's clearly for the wrong OS? – sevenseacat Dec 02 '13 at 07:05
1

@sevenseacat 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. – E.E.33 Dec 02 '13 at 07: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. – Donato May 23 '15 at 20:46
That made it work. Key point being that postgresql needs to be installed on your machine. – JackHasaKeyboard Nov 13 '15 at 19:31

score 78 · Accepted Answer · edited Mar 25 '13 at 06:47

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.

edited Mar 25 '13 at 06:47

Perception

79,279
19
185
195

answered Mar 12 '12 at 15:03

Ethan

1,616
14
8

As a note, the binary package from the Postgres site does not contain development headers or the `pg_config` program. – tadman Mar 12 '12 at 15:43
3

The binary package from here: http://www.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. – Michael Granger Mar 12 '12 at 23:53
8

Wouldn't `which pg_config` be faster than `find / -name pg_config`? – Justin D. Nov 03 '12 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/ – Rod Paddock Nov 29 '13 at 20:46
13

On OSX you may also use brew to get the headers via `brew install libpqxx` and everything will go fine. – Vetsin Dec 13 '13 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 – Mike McCoy Dec 29 '13 at 20:23
Mine was `gem install pg -- --with-pg-config=/Library/PostgreSQL/9.2/bin/pg_config` – Mike Atlas Jan 02 '14 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 – jmstone617 Jan 23 '14 at 21:48
You can change this to: `gem install pg -- --with-pg-config=\`which pg_config\`` – vpontis Apr 28 '15 at 03:28

score 58 · Answer 3 · edited Jul 30 '15 at 19:02

58

If you're using Postgress.app then youll want access to its command-line tools. Enter the following line in your terminal or your PATH profile:

 PATH="/Applications/Postgres.app/Contents/MacOS/bin:$PATH"

gem install pg should now work. (This is what worked for me.)

Note New versions path looks like:

/Applications/Postgres.app/Contents/Versions/<version>/bin

edited Jul 30 '15 at 19:02

tybro0103

48,327
33
144
170

answered Oct 27 '13 at 18:55

Ari

1,974
19
30

3

Thanks so much! I spent half an hour going through things that did not work and finally found this buried down here. :D – Peter Brown Nov 01 '13 at 21:45
1

Great solution that doesn't require brew. – lucian303 Nov 08 '13 at 07:29
7

Just be aware that the Postgre.app patch changed in the 93 version. it is now: /Applications/Postgres93.app/Contents/MacOS/bin – Alain Jan 06 '14 at 16:15
2

This worked for me, though my bin was in a very different place -> /Library/PostgreSQL/9.3/bin – Jeremiah Jan 31 '14 at 05:25
Postgres.app explains the updated path to use in this documentation page: http://postgresapp.com/documentation/cli-tools.html – Jeff French Jul 27 '14 at 21:54
5

This is now - `/Applications/Postgres.app/Contents/Versions/9.3/bin` as of 9.3.5 if you are using the Postgres.app – Ashley Sep 20 '14 at 18:54

score 22 · Answer 4 · answered Feb 11 '14 at 13:33

22

If you have homebrew, just type:

$ brew install postgresql

If you dont have it, download typing this in your terminal:

ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)"

answered Feb 11 '14 at 13:33

user2373148

463
6
9

score 12 · Answer 5 · answered Aug 21 '15 at 04:35

12

Search for libpq:

brew search libpq

Should output libpqxx

Then try install it:

brew install libpqxx

answered Aug 21 '15 at 04:35

jlucasps

890
7
8

score 8 · Answer 6 · answered Jul 23 '12 at 17:43

8

You only need to install libpq-dev:

sudo apt-get install libpq-dev

Then the gem should install just fine.

answered Jul 23 '12 at 17:43

Travis Reeder

38,611
12
87
87

In my case only this helped. Thanx! – kovpack Jul 25 '14 at 22:33

score 7 · Answer 7 · answered Oct 01 '14 at 01:19

7

Follow the post-installation instructions: http://postgresapp.com/documentation/configuration-ruby.html

To install the pg gem, make sure you have set up your $PATH correctly (as specified in http://postgresapp.com/documentation/cli-tools.html), then run

sudo ARCHFLAGS="-arch x86_64" gem install pg

I strongly recommend reading both pages. Just skimmed them and lost 1 hour of my life. Read them, problem solved.

answered Oct 01 '14 at 01:19

CGK

2,662
21
24

Works on OSX 10.9.5, default ruby version 2.0, rbenv local version 1.9.3. – jlucasps Aug 21 '15 at 04:53
Works on OSX 10.11 THANKS – Yarin Jan 25 '16 at 14:37
Works on OSX 10.11.4. Thanks!! – Martyn Chamberlin Apr 01 '16 at 06:08

score 3 · Answer 8 · answered Jul 30 '12 at 18:45

The problem I had was that for some reason it was trying to compile with /usr/bin/gcc-4.2. I found that out by changing try_cpp in mkmf.rb (which I saw in the stack trace) to raise an exception with the compile line that was failing.

I soft-linked gcc to gcc-4.2 and it worked:

sudo ln -s /usr/bin/gcc /usr/bin/gcc-4.2

Why was it trying to use gcc-4.2? No idea.

The actual compile line:

/usr/bin/gcc-4.2 -E -I/Users/dfrankow/.rvm/rubies/ruby-1.9.3-p125/include/ruby-1.9.1/x86_64-darwin11.4.0 -I/Users/dfrankow/.rvm/rubies/ruby-1.9.3-p125/include/ruby-1.9.1/ruby/backward -I/Users/dfrankow/.rvm/rubies/ruby-1.9.3-p125/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE   -I/usr/local/Cellar/postgresql/9.1.4/include  -O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wno-long-long -Wno-missing-field-initializers -Wpointer-arith -Wwrite-strings -Wdeclaration-after-statement -Wshorten-64-to-32 -Wimplicit-function-declaration  -fno-common -pipe  conftest.c -o conftest.i (RuntimeError)

score 3 · Answer 9 · answered Dec 09 '13 at 20:30

3

I got the same issue but my Postgres was install in

/Library/PostgreSQL/9.3

Updated the ~/.bash_profile by adding:

export PATH=/Library/PostgreSQL/9.3/bin:$PATH

Open a new terminal, run bundle update and also it worked for me. Thanks Ari.

answered Dec 09 '13 at 20:30

Trang Tung Nguyen

316
4
14

but for me to work need to check the version then export PATH=/Applications/Postgres.app/Contents/Versions/9.4/bin:$PATH – PKul Jan 29 '15 at 09:59

score 1 · Answer 10 · answered Sep 01 '14 at 14:08

You can set a build config option bundle config build.pg --with-pg-config=/Applications/Postgres.app/Contents/Versions/9.3/bin/pg_config and use gem install pg without any options (the path to pg_config may be different for you, this one is for the Postgresapp 9.3.5.0)

score 1 · Answer 11 · answered Dec 20 '14 at 19:26

I had the same problem in my openSUSE13.1 KDE machine. Before that issue I encountered I had installed only the packages postgresql and postgresql-server using zypper command. Then installed again 2 more packages :

[arup@to_do_app]$ sudo zypper in postgresql-devel postgresql-contrib
root's password:
Loading repository data...
Reading installed packages...
Resolving package dependencies...
#....

Then, I ran again bundle install, and success!!!

score 0 · Answer 12 · answered Mar 26 '13 at 22:36

For a working OSX solution see this guide http://krugerdavid.com/journal/how-to-install-xcode-homebrew-git-rvm-postgresql-ruby-1-9-3-on-snow-leopard/

It will walk you through installing PostgreSQL using homebrew. Tested and working for me on OSX 10.8.3, PostgreSQL 9.2.3, and Ruby 2.0.0-p0

score 0 · Answer 13 · answered Dec 02 '13 at 20:43

First, uninstall any Homebrew versions. The --force option makes it uninstall all versions.

brew rm postgresql --force

Change paths accordingly for your version.

sudo /sbin/SystemStarter stop postgresql-8.4
sudo rm -rf /Applications/PostgreSQL\ 8.4
sudo rm -rf /etc/postgres-reg.ini
sudo rm -rf /Library/StartupItems/postgresql-8.4
sudo rm -rf /Library/PostgreSQL/8.4
sudo dscl . delete /users/postgres

Edit /etc/profile and delete any lines that reference "postgres".

nano /etc/profile

Install PostgresSQL

brew update
brew install postgresql

Install de PG GEM

gem install pg

That's it. Regards.

score 0 · Answer 14 · answered Feb 10 '14 at 08:51

You can first check to see if you have a postrgresql file in your terminal by going to lib file. going cd ~/opt/local/lib/ and then type ls and the enter button. This will show you a list of all the files that are located in the lib directory.

1.if you dont have postreseql you can download through macports. sudo port install postgresql93 @9.3.2_1

Now cd back into your folder which you are trying to bundle install

getting your pg to work with your postgesql file you have or just downloaded gem install pg -- --with-pg-config=/opt/local/lib/postgresql93/bin/pg_config

now run bundle install

score 0 · Answer 15 · edited Aug 06 '16 at 12:34

0

On Fedora:

dnf install postgresql-devel

edited Aug 06 '16 at 12:34

Andrew Marshall

95,083
20
220
214

answered Aug 06 '16 at 12:06

Mayuresh Srivastava

1,332
17
24

score 0 · Answer 16 · answered Aug 15 '16 at 02:14

0

What worked for me on El Capitan was upgrading ruby from the system default to 2.3.1 seemed to find the correct libraries that the pg gem needed.

answered Aug 15 '16 at 02:14

Abe Petrillo

2,368
23
34

Rails 3 - can't install pg gem

16 Answers16

Linked

Related