Error in migrating the Postgres database

madhuri_godade · October 24, 2009, 5:01pm

I want to create a rails application using postgres database.
Update a username and password terp and agile respectively.
When i run the command rake db:create and rake db:migrate
it is giving mi an error…

uninitialized constant
ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::PGconn

Please tell me how to resolve this error…

madhuri_godade · October 24, 2009, 5:09pm

Hope u have the postgre adapter installed.

madhuri_godade · October 29, 2009, 5:54am

Hello sir,

I have installed

gem to install is ruby-pg

gem to install is postgres

gem to install is postgres-pr

But still getting the same error…
uninitialized constant
ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::PGconn

Is there any configuration needed for the postgreSQLAdapter…
Please tell me how to resolve this error…

madhuri_godade · November 2, 2009, 10:20am

put in config/environment.rb this string:

config.gem “postgres”

or another gem which you use

madhuri_godade · December 17, 2009, 12:50pm

On Ubuntu 9.10 I solved same error by installing libpgsql-ruby:
sudo aptitude install libpgsql-ruby