Forum: Ruby on Rails 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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/18/2012 01:29 AM, Saravanan P wrote:
> 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.

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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iQEcBAEBAgAGBQJQWAc0AAoJEEpR26xcXD1etjkH/R+M6ywCsMptwDpG2NvQxp0I
QULmxdflzw0V5/c50trpd+DFo3gkQuKLuMchTZ6akcckp7+IFUy8yd1sPAfheXOF
UympBgajZMYeqv1EGSJEGq0XKtR9a28s97NxPzxzddbqtoswmxnl9hgLVunuK2il
135FUGxxRgRbJhbfmbCYzR+a5r32FxP+lc8fODJCHEWhQhyxlfJryTTHW6YXp88r
lDWN545LYUMmL/4rupI45vusIxeom70wrMFeXug5qdk1urkL/nxTAR8kG1Zp2+8w
4NlrRckzbWutjJNTMK3NuPQTOcWFXeg7jjJUY4CJDtF3zr6NEdBSwvVwqYoCRh0=
=34RQ
-----END PGP SIGNATURE-----

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?


On Tue, Sep 18, 2012 at 11:01 AM, Christopher R. Maden 
<crism@maden.org>wrote:

> The pg gem is only a way to communicate with the Postgres server; make
> -----BEGIN PGP SIGNATURE-----
> -----END PGP SIGNATURE-----
>
--
Regards by
Saravanan.P

On 18 September 2012 06:29, Saravanan P <saravanan.p@shriramits.com> 
wrote:
> 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)

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-<version>. 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 :(

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


On Tue, Sep 18, 2012 at 7:50 PM, Ashwin Mangale 
<ashwin.mangale@gmail.com>wrote:

>> am using ubuntu 12.04. In my error
>> saying PQconnectdb() in -lpq... no, which mean?
>>> >
>>> Chris Maden, text nerd  <URL: http://crism.maden.org/ >
>>> 135FUGxxRgRbJhbfmbCYzR+a5r32FxP+lc8fODJCHEWhQhyxlfJryTTHW6YXp88r
>>> rubyonrails-talk+unsubscribe@googlegroups.com.
>>  --
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to
> rubyonrails-talk+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



--
Regards by
Saravanan.P

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





Saravanan P wrote in post #1076481:
> Thanks
>
> I already installed libpq-dev package and now only i
> installed postgresql-server-dev-9.1 package. But no luck still same
> error :(
>
> any help!

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)

On 19 September 2012 12:04, Federico R. <lists@ruby-forum.com> wrote:
> 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...

Instead of compiling it by hand, you specify the missing headers in the 
gem
command:

rvmsudo gem install pg -- --with-pg-lib=/usr/pgsql/lib/
--with-pg-config=/usr/pgsql/bin/pg_config

If you need to bundle install pg (or other gem that uses it), you could 
use
a bundle config file:

bundle config build.pg --with-pg-lib=/usr/pgsql/lib/
--with-pg-config=/usr/pgsql/bin/pg_config

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-ins...

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