Not able to install pg gem on Ubuntu 12.10

Question

I am using Ubuntu 12.10 64-bit and I have following packages installed :

dpkg --get-selections | grep postgre

output:

postgresql
postgresql-9.1
postgresql-client
postgresql-client-9.1
postgresql-client-common
postgresql-common
postgresql-contrib
postgresql-contrib-9.1
postgresql-server-dev-9.1
postgresql-server-dev-all
libpq-dev
libpq5

rvm 1.17.9

ruby 1.9.3p362 (2012-12-25 revision 38607) [x86_64-linux]

I am not able to install pg gem I am getting following error :

ERROR:  Error installing pg:
    ERROR: Failed to build gem native extension.

        /home/vedarthk/.rvm/rubies/ruby-1.9.3-p362/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)

I have also tried following commands but the output is same as above :

gem install pg -- --with-pg-include=/usr/include/postgresql/libpq --with-pg-lib=/usr/lib/postgresql/9.1/lib


gem install pg -- --with-pg-include=/usr/include/postgresql --with-pg-lib=/usr/lib/postgresql/9.1/lib

Answer 1

Try installing PostgreSQL development headers:

sudo apt-get install libpq-dev

Answer 2

Try - $ sudo apt-get install ruby-dev

sudo gem install pg won't work has that solution and it worked for me.

Answer 3

I had a similar problem on RHEL 6.4, the following worked for me:

gem install /opt/redmine/vendor/cache/pg-0.18.4.gem --local -- --with-pg-dir=/usr/pgsql-9.4/

I setup PostgreSQL from their own repos.