如何杀死我所有的postgresql连接?
我试着耙db:下降，但我得到:
ERROR: database "database_name" is being accessed by other users
DETAIL: There are 1 other session(s) using the database.
我尝试过关闭我从ps -ef | grep postgres中看到的进程，但这也不起作用:
kill: kill 2358 failed: operation not permitted
当前回答
MacOS，如果postgresql安装了brew:
brew services restart postgresql
UBUNTU,
首先用这个检查(在后台运行的kill服务器)
sudo kill -9 $(lsof -i :3000 -t)
如果你没有找到pid，那么你只需要重新启动 Postgresql服务的命令如下所示:
sudo service postgresql restart
其他回答
答案隐藏在上面的一条评论中:brew服务重新启动postgresql
当然，上面的一个答案给了我在Windows中解决它的想法。
在Windows中打开Services，找到Postgres服务并重新启动它。
也许只是重启postgres => sudo服务postgresql重启
没有必要放弃。只需删除并重新创建公共模式。在大多数情况下，这有完全相同的效果。
namespace :db do
desc 'Clear the database'
task :clear_db => :environment do |t,args|
ActiveRecord::Base.establish_connection
ActiveRecord::Base.connection.tables.each do |table|
next if table == 'schema_migrations'
ActiveRecord::Base.connection.execute("TRUNCATE #{table}")
end
end
desc 'Delete all tables (but not the database)'
task :drop_schema => :environment do |t,args|
ActiveRecord::Base.establish_connection
ActiveRecord::Base.connection.execute("DROP SCHEMA public CASCADE")
ActiveRecord::Base.connection.execute("CREATE SCHEMA public")
ActiveRecord::Base.connection.execute("GRANT ALL ON SCHEMA public TO postgres")
ActiveRecord::Base.connection.execute("GRANT ALL ON SCHEMA public TO public")
ActiveRecord::Base.connection.execute("COMMENT ON SCHEMA public IS 'standard public schema'")
end
desc 'Recreate the database and seed'
task :redo_db => :environment do |t,args|
# Executes the dependencies, but only once
Rake::Task["db:drop_schema"].invoke
Rake::Task["db:migrate"].invoke
Rake::Task["db:migrate:status"].invoke
Rake::Task["db:structure:dump"].invoke
Rake::Task["db:seed"].invoke
end
end
OSX, Postgres 9.2(已安装自制程序)
$ launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
$ pg_ctl restart -D /usr/local/var/postgres
$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
如果你的datadir在其他地方，你可以通过检查ps aux | grep postgres的输出来找到它
