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
– sanny Sin, Commented Mar 11, 2013 at 13:19
You can look at this post : stackoverflow.com/questions/7086654/… — rbinsztock
– rbinsztock, Commented Mar 15, 2013 at 10:25

Anton Roslov · Accepted Answer · 2013-03-15 10:10:18Z

3

+25

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

answered Mar 15, 2013 at 10:10

Anton Roslov

7984 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aleks · Accepted Answer · 2013-03-15 10:34:17Z

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, 2013 at 10:34

Aleks

5,5484 gold badges41 silver badges71 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:21:05Z

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, 2017 at 12:21

CommunityBot

11 silver badge

answered Mar 13, 2013 at 13:15

Milan Köpke

1,1337 silver badges8 bronze badges

2 Comments

szatan Over a year ago

Problem is that I work on windows (yeah, I know it's wrong but I am only begginer) so sudo is not working here

Milan Köpke Over a year ago

Then maybe take a look at this one: stackoverflow.com/questions/7086654/…

moon · Accepted Answer · 2019-02-11 19:12:16Z

0

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

answered Feb 11, 2019 at 19:12

moon

1,40314 silver badges14 bronze badges

Collectives™ on Stack Overflow

active record postgresql adapter error in rails

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related