Can't find the 'libpq-fe.h header when trying to install pg gem

It looks like in Ubuntu that header is part of the libpq-dev package (at least in the following Ubuntu versions: 11.04 (Natty Narwhal), 10.04 (Lucid Lynx), 11.10 (Oneiric Ocelot), 12.04 (Precise Pangolin), 14.04 (Trusty Tahr) and 18.04 (Bionic Beaver)):

.../usr/include/postgresql/libpq-fe.h...

So try installing libpq-dev or its equivalent for your OS:

• For Ubuntu/Debian systems: sudo apt-get install libpq-dev
• On Red Hat Linux (RHEL) systems: yum install postgresql-devel
• For Mac Homebrew: brew install postgresql
• For Mac MacPorts PostgreSQL: gem install pg -- --with-pg-config=/opt/local/lib/postgresql[version number]/bin/pg_config
• For OpenSuse: zypper in postgresql-devel
• For ArchLinux: pacman -S postgresql-libs

On macOS (previously Mac OS X and OS X), use Homebrew to install the proper headers:

brew install postgresql

and then running

gem install pg

should work.

Alternatively, instead of installing the whole postgresql, you can brew install libpq and export the correct PATH and PKG_CONFIG_PATH as explained in the 'Caveats' section

I had also tried doing gem install libpq-dev, but I received this error:

Can't find the 'libpq-fe.h header*** extconf.rb failed ***

However I found that installing with sudo apt-get (which I try to avoid using with Ruby on Rails) worked, i.e.

sudo apt-get install libpq-dev# orapt-get install postgres-server-dev-{pg.version}# for postgresql 9.4 on Ubuntu 14.04

then I was able to do

gem install pg

without issues.