pg gem error

gem install pg give the following error, please help how can i solve this

Building native extensions. This could take a while…

ERROR: Error installing pg:

ERROR: Failed to build gem native extension.

/home/saravanan/.rvm/rubies/ruby-1.9.3-p194/bin/ruby extconf.rb

checking for pg_config… yes

Using config values from /usr/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

Can’t 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

--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/saravanan/.rvm/rubies/ruby-1.9.3-p194/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

--with-pqlib

--without-pqlib

--with-libpqlib

--without-libpqlib

--with-ms/libpqlib

--without-ms/libpqlib

Gem files will remain installed in /home/saravanan/.rvm/gems/ruby-1.9.3-p194/gems/pg-0.14.1 for inspection.

Results logged to /home/saravanan/.rvm/gems/ruby-1.9.3-p194/gems/pg-0.14.1/ext/gem_make.out

The pg gem is only a way to communicate with the Postgres server; make
sure you have postgresql and postgresql-dev installed on your system
(with Linux, there should be apt or rpm packages available; not sure
about Windows).

~Chris
- --
Chris Maden, text nerd <URL: http://crism.maden.org/ >
LIVE FREE: vote for Gary Johnson, Libertarian for President.
     <URL: http://garyjohnson2012.com/ > <URL: http://lp.org/ >
GnuPG fingerprint: DB08 CF6C 2583 7F55 3BE9 A210 4A51 DBAC 5C5C 3D5E

i already installed postgresql. “postgresql-dev” i think its not a package, did you mean “libpq-dev”. if yes i already installed that too. i am using ubuntu 12.04. In my error

checking for pg_config… yes

Using config values from /usr/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

saying PQconnectdb() in -lpq… no, which mean?

googling for
Can't find the PostgreSQL client library (libpq)
shows a number of hits that may be relevant to your problem

Colin

On Ubuntu, there is one libpq-dev ( which you have installed ) and the other is postgresql-server-dev-. I think you need both.

-Ashwin

Thanks

I already installed libpq-dev package and now only i installed postgresql-server-dev-9.1 package. But no luck still same error :frowning:

any help!

Building native extensions. This could take a while…

ERROR: Error installing pg:

ERROR: Failed to build gem native extension.

/home/saravanan/.rvm/rubies/ruby-1.9.3-p194/bin/ruby extconf.rb

checking for pg_config… yes

Using config values from /usr/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

Can’t 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

--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/saravanan/.rvm/rubies/ruby-1.9.3-p194/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

--with-pqlib

--without-pqlib

--with-libpqlib

--without-libpqlib

--with-ms/libpqlib

--without-ms/libpqlib

Gem files will remain installed in /home/saravanan/.rvm/gems/ruby-1.9.3-p194/gems/pg-0.14.1 for inspection.

Results logged to /home/saravanan/.rvm/gems/ruby-1.9.3-p194/gems/pg-0.14.1/ext/gem_make.out

Did you find a solution? I have the same problem since days! :frowning:

Saravanan P wrote in post #1076481:

I am getting crazy about this problem... Basically pg compiles for my
system ruby (installed via apt-get), also compiles for my RVM ruby 1.8
BUT when I try to compile it for RVM ruby 1.9 it will fail!!! Why??

Error is always:
Can't find the PostgreSQL client library (libpq)

I am getting crazy about this problem... Basically pg compiles for my
system ruby (installed via apt-get), also compiles for my RVM ruby 1.8
BUT when I try to compile it for RVM ruby 1.9 it will fail!!! Why??

Which 1.9?

Is it the same version of the pg gem that in the case that compiles
and the one that doesn't?

Colin

1.9.3, I fixed it...

I had to rename a "lib" folder inside the .rvm directory, compile the
gem separately and then re-rename the folder...

My error wasn't related to any missing headers, pg was being linked with
the wrong libraries.

This was my exact same problem:

http://stackoverflow.com/questions/8814924/gem-install-pg-can-not-bind-to-libpq

Just for your information, the solution posted on stacked overflow fixed
my problem...