Quickly close database connections on the command line
One slightly annoying thing about Postgres over MySQL is that trying to reset a database with
rake db:migrate:reset fails if there are connected clients and as I use Pow for development, killing the process doesn’t always free up the connections.
To get around this you can quickly kill all connections with this command:
ps x -o pid,command | grep postgres | grep my_database | cut -f 1 -d " " | xargs kill