Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)

by

I had the same problem. To solve it, resetting the database is more easier.

  • heroku rake db:reset (‘heroku run rake db:reset’ if you’re on cedar)
  • heroku rake db:migrate (‘heroku run rake db:migrate’ if you’re on cedar)

Then, migration was done successfully for my case 🙂

While this is a good solution in this context, don’t do it on production. It will delete all the records from your database

More Related Contents:

  1. Change from SQLite to PostgreSQL in a fresh Rails project
  2. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  3. Can I write PostgreSQL functions on Ruby on Rails?
  4. New data not persisting to Rails array column on Postgres
  5. Changing a column type to longer strings in rails
  6. Rails extending ActiveRecord::Base
  7. Deploying RoR app to Heroku with SQLite 3 fails
  8. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  9. Rails ActiveRecord date between
  10. Rails: How to reference images in CSS within Rails 4
  11. Random record in ActiveRecord
  12. What is the easiest way to duplicate an activerecord record?
  13. How to solve error “Missing `secret_key_base` for ‘production’ environment” (Rails 4.1)
  14. How can I avoid running ActiveRecord callbacks?
  15. Rails 4: List of available datatypes
  16. Rails 2.3-style plugins and deprecation warnings running task in Heroku
  17. ActiveRecord OR query Hash notation
  18. Rails: Access to current_user from within a model in Ruby on Rails
  19. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  20. Add a reference column migration in Rails 4
  21. Heroku upload-Precompiling assets failed
  22. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  23. docker postgres with initial data is not persisted over commits
  24. query , can not select column count
  25. Validate uniqueness of multiple columns
  26. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  27. Long running delayed_job jobs stay locked after a restart on Heroku
  28. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  29. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]
  30. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?

Leave a Comment