Postgres DROP db - right way

psql-drop-db

/* Disable connection to Database */
UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'mydb';

/* Get postgres process id */
SELECT pg_backend_pid();

/* Force Disconnect all clients ( use pid from previous step) */
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'mydb';

/* Finaly Drop database */
DROP DATABASE mydb;