Can install PG gem in Ruby on Rails install

wonderphil

Just wondering if anyone else has seen this issue and how to fix:

current directory: /home/bargainhunter/apps/staging-api/env/gems/pg-1.5.8/ext
/opt/ruby32/bin/ruby -I/opt/ruby32/lib/ruby extconf.rb
Calling libpq with GVL unlocked
checking for pg_config... no
checking for libpq per pkg-config... no
Using libpq from
checking for libpq-fe.h... no
Can't find the 'libpq-fe.h header
*****************************************************************************

Unable to find PostgreSQL client library.

Please install libpq or postgresql client package like so:
  sudo apt install libpq-dev
  sudo yum install postgresql-devel
  sudo zypper in postgresql-devel
  sudo pacman -S postgresql-libs

or try again with:
  gem install pg -- --with-pg-config=/path/to/pg_config

or set library paths manually with:
  gem install pg -- --with-pg-include=/path/to/libpq-fe.h/ --with-pg-lib=/path/to/libpq.so/

*** 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
	--without-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=/opt/ruby32/bin/$(RUBY_BASE_NAME)
	--with-pg
	--without-pg
	--enable-gvl-unlock
	--disable-gvl-unlock
	--enable-windows-cross
	--disable-windows-cross
	--with-pg-config
	--without-pg-config
	--with-pg_config
	--without-pg_config
	--with-libpq-dir
	--without-libpq-dir
	--with-libpq-include
	--without-libpq-include=${libpq-dir}/include
	--with-libpq-lib
	--without-libpq-lib=${libpq-dir}/lib
	--with-libpq-config
	--without-libpq-config
	--with-pkg-config
	--without-pkg-config
	--with-pg-dir
	--without-pg-dir
	--with-pg-include
	--without-pg-include=${pg-dir}/include
	--with-pg-lib
	--without-pg-lib=${pg-dir}/lib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  /home/bargainhunter/apps/staging-api/env/extensions/x86_64-linux/pg-1.5.8/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in /home/bargainhunter/apps/staging-api/env/gems/pg-1.5.8 for inspection.
Results logged to /home/bargainhunter/apps/staging-api/env/extensions/x86_64-linux/pg-1.5.8/gem_make.out

  /opt/ruby32/lib/ruby/rubygems/ext/builder.rb:119:in `run'
  /opt/ruby32/lib/ruby/rubygems/ext/ext_conf_builder.rb:28:in `build'
  /opt/ruby32/lib/ruby/rubygems/ext/builder.rb:187:in `build_extension'
  /opt/ruby32/lib/ruby/rubygems/ext/builder.rb:221:in `block in build_extensions'
  /opt/ruby32/lib/ruby/rubygems/ext/builder.rb:218:in `each'
  /opt/ruby32/lib/ruby/rubygems/ext/builder.rb:218:in `build_extensions'
  /opt/ruby32/lib/ruby/rubygems/installer.rb:846:in `build_extensions'
  /opt/ruby32/lib/ruby/bundler/rubygems_gem_installer.rb:72:in `build_extensions'
  /opt/ruby32/lib/ruby/bundler/rubygems_gem_installer.rb:28:in `install'
  /opt/ruby32/lib/ruby/bundler/source/rubygems.rb:202:in `install'
  /opt/ruby32/lib/ruby/bundler/installer/gem_installer.rb:54:in `install'
  /opt/ruby32/lib/ruby/bundler/installer/gem_installer.rb:16:in `install_from_spec'
  /opt/ruby32/lib/ruby/bundler/installer/parallel_installer.rb:156:in `do_install'
  /opt/ruby32/lib/ruby/bundler/installer/parallel_installer.rb:147:in `block in worker_pool'
  /opt/ruby32/lib/ruby/bundler/worker.rb:62:in `apply_func'
  /opt/ruby32/lib/ruby/bundler/worker.rb:57:in `block in process_queue'
  /opt/ruby32/lib/ruby/bundler/worker.rb:54:in `loop'
  /opt/ruby32/lib/ruby/bundler/worker.rb:54:in `process_queue'
  /opt/ruby32/lib/ruby/bundler/worker.rb:90:in `block (2 levels) in create_threads'

An error occurred while installing pg (1.5.8), and Bundler cannot continue.

In Gemfile:
  pg

peter

wonderphil Please ensure your project's Gemfile includes the pg gem like so:

gem "pg"

Then SSH into your Rails application's shell user account and run the following commands to install the PostgreSQL dependencies for Ruby (substituting your_project with your Rails project name):

cd ~/apps/staging-api/
source setenv
export PATH=/usr/pgsql-14/bin/:$PATH
cd your_project
bundle install

You must also configure your project environment's database.yml section as follows:

production:
  <<: *default
  adapter: postgresql
  database: your_database_name
  username: your_database_user_name
  password: your_database_user_password

If the problem persists, please open a support ticket, and we'll be happy to look further into it.

wonderphil

Thanks

The gem file already had the correct gem listed, but adding the path made it work.

Thanks