Programmatically drop all connections

Question

At work, we do distributed testing, where rsync out to everyone elses machine and distribute out test files to speed up the testing process. One issue we are running into is that if someone has an instance of pgadmin open, it won't let us reset the test database due to connections being open.

Is there any way we can programmatically kill connections in either ruby or pg that doesn't involve restarting the daemon?

Answer 1

Use pg_terminate_backend() to kill the connections you want to kill.