\list or \l to list your database
terminate any connections by using the following command. example if databse named YourDatabase
select pg_terminate_backend(pid) from pg_stat_activity where datname=’YourDatabase’;
*use procid instead of pid for older versions of postgres
DROP DATABASE “YourDatabase”;
Now your database is gone.