Need help -FATAL: database "catarse_development" does not exist

Hi i try to run this rake db:migrate

How i fix this i get this [root@localhost catarse]# rake db:migrate /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:229:in `block in require': iconv will be deprecated in the future, use String#encode instead.

            You no longer need to have jasmine.rake in your project, as it is now automatically loaded             from the Jasmine gem. To silence this warning, set "USE_JASMINE_RAKE=true" in your environment             or remove jasmine.rake.

problem while using OauthProvider model: 'FATAL: database "catarse_development" does not exist ' [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message. rake aborted! FATAL: database "catarse_development" does not exist /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `initialize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `new' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `connect' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:548:in `initialize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_handling.rb:79:in `retrieve_connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_handling.rb:53:in `connection' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/model_schema.rb:203:in `table_exists?' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/attribute_methods/primary_key.rb:92:in `get_primary_key' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/attribute_methods/primary_key.rb:77:in `reset_primary_key' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/attribute_methods/primary_key.rb:65:in `primary_key' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_record/mass_assignment_security/attribute_assignment.rb:15:in `attributes_protected_by_default' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:332:in `block in protected_attributes_configs' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:217:in `yield' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:217:in `default' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:217:in `protected_attributes' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:123:in `block in attr_protected' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:122:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/protected_attributes-1.0.5/lib/active_model/mass_assignment_security.rb:122:in `attr_protected' /root/catarse/app/models/contribution.rb:34:in `<class:Contribution>' /root/catarse/app/models/contribution.rb:2:in `<top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:424:in `load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:424:in `block in load_file' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:616:in `new_constants_in' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:423:in `load_file' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:324:in `require_or_load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:463:in `load_missing_constant' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:184:in `const_missing' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:226:in `const_get' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:226:in `block in constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `inject' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/core_ext/string/inflections.rb:66:in `constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:309:in `block in observe' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:309:in `collect!' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:309:in `observe' /root/catarse/app/observers/contribution_observer.rb:2:in `<class:ContributionObserver>' /root/catarse/app/observers/contribution_observer.rb:1:in `<top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:424:in `load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:424:in `block in load_file' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:616:in `new_constants_in' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:423:in `load_file' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:324:in `require_or_load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:463:in `load_missing_constant' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:184:in `const_missing' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:226:in `const_get' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:226:in `block in constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `inject' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/inflector/methods.rb:224:in `constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/core_ext/string/inflections.rb:66:in `constantize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:183:in `instantiate_observer' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:108:in `block in instantiate_observers' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:108:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/active_model/observing.rb:108:in `instantiate_observers' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/railtie.rb:24:in `block (2 levels) in <class:Railtie>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:38:in `instance_eval' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:38:in `execute_hook' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:28:in `block in on_load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:27:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:27:in `on_load' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/rails-observers-0.1.2/lib/rails/observers/railtie.rb:23:in `block in <class:Railtie>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:36:in `call' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:45:in `block in run_load_hooks' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:44:in `each' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/lazy_load_hooks.rb:44:in `run_load_hooks' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/application/finisher.rb:62:in `block in <module:Finisher>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/initializable.rb:30:in `instance_exec' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/initializable.rb:30:in `run' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/initializable.rb:55:in `block in run_initializers' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/initializable.rb:54:in `run_initializers' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/application.rb:215:in `initialize!' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/railtie/configurable.rb:30:in `method_missing' /root/catarse/config/environment.rb:7:in `<top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:229:in `require' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:229:in `block in require' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:214:in `load_dependency' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activesupport-4.0.2/lib/active_support/dependencies.rb:229:in `require' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/application.rb:189:in `require_environment!' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/railties-4.0.2/lib/rails/application.rb:250:in `block in run_tasks_blocks' /usr/local/rvm/gems/ruby-1.9.3-p484/bin/ruby_executable_hooks:15:in `eval' /usr/local/rvm/gems/ruby-1.9.3-p484/bin/ruby_executable_hooks:15:in `<main>' Tasks: TOP => db:migrate => environment (See full trace by running task with --trace)

Does it not seem pretty apparent that you can't run a migration on a non-existent database?

And the answer to that situation would be "create it first"?

You might want to try `rake -T` to see what kind of things you can do with rake besides run migrations.

P.S. Doing development-related tasks as 'root' is almost certainly a Very Bad Idea -- just sayin' ...

HTH,

Hi i try to do that createdb mytestdb [root@localhost catarse]# createdb mytestdb createdb: could not connect to database postgres: FATAL: role "root" does not exist give this Errer thanks

you want to do: rake db:create

yes i want to rake db:create and fix the Errer 'FATAL: database "catarse_development" does not exist How i fix that

I think that it was rake db:migrate that gave you that error, I think it unlikely that db:create also gave it. If it does then copy/paste the command and result here.

Also please remember to quote the previous message, this is an email list not a forum, though you may be accessing it via a forum like interface.

Colin