Rails + Postgres drop error: database is being accessed by other users

by

If you kill the running postgresql connections for your application, you can then run db:drop just fine. So how to kill those connections? I use the following rake task:

# lib/tasks/kill_postgres_connections.rake
task :kill_postgres_connections => :environment do
  db_name = "#{File.basename(Rails.root)}_#{Rails.env}"
  sh = <<EOF
ps xa \
  | grep postgres: \
  | grep #{db_name} \
  | grep -v grep \
  | awk '{print $1}' \
  | xargs kill
EOF
  puts `#{sh}`
end

task "db:drop" => :kill_postgres_connections

Killing the connections out from under rails will sometimes cause it to barf the next time you try to load a page, but reloading it again re-establishes the connection.

More Related Contents:

  1. Ignoring time zones altogether in Rails and PostgreSQL
  2. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  3. Can’t find the PostgreSQL client library (libpq)
  4. PG::ConnectionBad – could not connect to server: Connection refused
  5. Postgres could not connect to server
  6. Can not connect to local PostgreSQL
  7. Rails: Installing PG gem on OS X – failure to build native extension
  8. Repairing Postgresql after upgrading to OSX 10.7 Lion
  9. PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list
  10. Impossible to Install PG gem on my mac with Mavericks
  11. Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?
  12. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  13. Change from SQLite to PostgreSQL in a fresh Rails project
  14. Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)
  15. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  16. docker postgres with initial data is not persisted over commits
  17. Installing Postgres on windows for use with Ruby-on-Rails
  18. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  19. Rails auto-assigning id that already exists
  20. Rails: PG::UndefinedTable: ERROR: relation “…” does not exist
  21. Rails Migrations: tried to change the type of column from string to integer
  22. Can’t install pg gem on Mountain Lion
  23. Store the day of the week and time?
  24. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  25. Rails: FATAL – Peer authentication failed for user (PG::Error)
  26. Changing a column type to longer strings in rails
  27. Cannot install pg gem in Mavericks with Postgres.app
  28. Adding foreign key to a rails model
  29. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  30. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?

Leave a Comment