Pg gem error

aris · September 18, 2012, 7:30am

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

Saravanan_P · September 18, 2012, 7:32am

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

Saravanan_P · September 18, 2012, 7:42am

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
[email protected]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

Saravanan_P · September 18, 2012, 4:23pm

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

-Ashwin

Saravanan_P · September 18, 2012, 4:15pm

On 18 September 2012 06:29, Saravanan P [email protected]
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

Saravanan_P · September 19, 2012, 12:53pm

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!

Saravanan_P · September 18, 2012, 4:59pm

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
[email protected]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
[email protected].
–

–
You received this message because you are subscribed to the Google G.
“Ruby on Rails: Talk” group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit https://groups.google.com/groups/opt_out.

–
Regards by
Saravanan.P

Saravanan_P · September 19, 2012, 1:04pm

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)

Saravanan_P · September 20, 2012, 1:30pm

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…

Saravanan_P · September 20, 2012, 4:54pm

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

Saravanan_P · September 20, 2012, 5:07pm

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

Saravanan_P · September 19, 2012, 6:44pm

On 19 September 2012 12:04, Federico R. [email protected] 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

Saravanan_P · September 21, 2012, 10:21am

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

Saravanan_P · September 20, 2012, 5:08pm

This was my exact same problem: