How to close existing connections to a DB

This should disconnect everyone else, and leave you as the only user:

alter database YourDb set single_user with rollback immediate

Note: Don’t forget

alter database YourDb set MULTI_USER

after you’re done!