Ruby gem, for dropping all connections to current database.
Sometimes we got exception, while trying drop current database with opened connections by rake task:
$ rake db:drop
PG::ObjectInUse: ERROR: database "my_database" is being accessed by other users
DETAIL: There is 1 other session using the database.
: DROP DATABASE IF EXISTS "mila_development"
...
The rtask-db-drop-connections
solves this issue. It contains the rake task db:drop_connections
for dropping all connections to
current database configured in config/database.yml
. (Currently PostgreSQL DBMS supports only)
include this line in your rails Gemfile
:
gem 'rtask-db-drop-connections', '~> 1.0'
and execute
bundle install
For dropping all connections to current Rails database (configured in config/database.yml
) you can execute this command:
rake db:drop_connections
If you want execute db:drop_connections
automatically before the task db:drop
, you can create file
lib/tasks/db/drop_connections.rake
with content:
# file: lib/tasks/db/drop_connections.rake
# Using gem rtask-db-drop-connections to extend db:drop functionality
Rake::Task['db:drop'].enhance [:drop_connections]
then, when you will execute:
rake db:drop
first, all connections to database will be reset, and then the rake db:drop
will be executed itself.
Also you can call drop_all_connections
method directly from anywhere:
PostgresConnectionHelper::drop_all_connections 'database', 'username', 'password'
include this line in your rails Gemfile
:
gem 'rtask-db-drop-connections', '~> 1.0', git: 'https://github.com/zencodepro/rtask-db-drop-connections.git'
and execute
bundle install
Clone git repository to #{Rails.root}/vendor/gems
git clone https://github.com/zencodepro/rtask-db-drop-connections.git vendor/gems/rtask-db-drop-connections
then include this line in your rails Gemfile
:
gem 'rtask-db-drop-connections', '~> 1.0', :path => 'vendor/gems/rtask-db-drop-connections'
Uninstall old versions:
gem uninstall rtask-db-drop-connections-1.0.0.gem
gem cleanup rtask-db-drop-connections
Clone from github
git clone https://github.com/zencodepro/rtask-db-drop-connections.git /tmp/my_rtask
cd /tmp/my_rtask
Build:
gem build rtask-db-drop-connections.gemspec
Install
gem install rtask-db-drop-connections-1.0.0.gem'
- Add another DBMS support