active record postgresql adapter error in rails

Question

Here's my problem. I am trying to create a blog. I run 'rails new blog'. Everythign is OK until I try 'rake db:create'. It returns an error:

rake aborted!
Please install the postgresql adapter: `gem install activerecord-postgresql-adap
ter` (pg is not part of the bundle. Add it to Gemfile.)

When I try to install pg adapter I get this:

Temporarily enhancing PATH to include DevKit...
Building native extensions.  This could take a while...
ERROR:  Error installing activerecord-postgresql-adapter:
    ERROR: Failed to build gem native extension.

F:/Ruby200-x64/bin/ruby.exe extconf.rb
checking for pg_config... no
No pg_config... trying anyway. If building fails, please try again with
 --with-pg-config=/path/to/pg_config
 checking for libpq-fe.h... no
Can't find the 'libpq-fe.h header
*** 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.

My gemfile:

  source 'https://rubygems.org'

gem 'rails', '3.2.12'

# Bundle edge Rails instead:
# gem 'rails', :git => 'git://github.com/rails/rails.git'

gem "pg"

# Gems used only for assets and not required
# in production environments by default.
 group :assets do
  gem 'sass-rails',   '~> 3.2.3'
  gem 'coffee-rails', '~> 3.2.1'

  # See https://github.com/sstephenson/execjs#readme for more supported runtimes
  # gem 'therubyracer', :platforms => :ruby

  gem 'uglifier', '>= 1.0.3'
end

gem 'jquery-rails'

# To use ActiveModel has_secure_password
# gem 'bcrypt-ruby', '~> 3.0.0'

# To use Jbuilder templates for JSON
# gem 'jbuilder'

# Use unicorn as the app server
# gem 'unicorn'

# Deploy with Capistrano
# gem 'capistrano'

# To use debugger
# gem 'debugger'

Got any idea?

try to run `bundle install --path vendor/gems` Some time ago, that helped me — sanny Sin, Mar 11 '13 at 13:19
You can look at this post : http://stackoverflow.com/questions/7086654/installing-postgres-on-windows-for-use-with-ruby-on-rails — rbinsztock, Mar 15 '13 at 10:25

score 3 · Answer 1 · answered Mar 15 '13 at 10:10

Do you have Postgres installed? If so, make sure that pg_config.exe is in the PATH. Alternatively use either --with-pg-config or –with-pg-dir key:

gem install pg --with-pg-config=<path>

See details in https://github.com/ged/ruby-pg/blob/master/README-Windows.rdoc

score 2 · Answer 2 · answered Mar 15 '13 at 10:34

2

Uninstall pg gem, and install postgres-pr for windows

Remove from Gemfile:

gem "pg"

and put:

gem "postgres-pr"

and run:

bundle install or gem install postgres-pr or however you are installing gems

answered Mar 15 '13 at 10:34

Aleks

4,866
3
38
69

score 1 · Answer 3 · edited May 23 '17 at 12:21

1

You are missing the library for postgresql. You can install it like this:

sudo apt-get install libpq-dev

Maybe also take a look at this old question.

edited May 23 '17 at 12:21

Community

1
1

answered Mar 13 '13 at 13:15

Milan Köpke

1,133
7
8

Problem is that I work on windows (yeah, I know it's wrong but I am only begginer) so sudo is not working here – szatan Mar 13 '13 at 14:38
Then maybe take a look at this one: http://stackoverflow.com/questions/7086654/installing-postgres-on-windows-for-use-with-ruby-on-rails – Milan Köpke Mar 13 '13 at 14:45

score 0 · Answer 4 · answered Feb 11 '19 at 19:12

I got the same error and I solved by setting correct file permissions to postgresql_adapter.rb

cd [YOUR_ACTIVERECORD_GEM_PATH]/lib/active_record/connection_adapters
chmod 644 postgresql_adapter.rb

Somehow the file permissions of postgresql_adapter.rb were corrupted in my computer...

active record postgresql adapter error in rails

4 Answers4