If you are using a cloud solution provider and you don't have superuser rights, you can't drop postgres database. You can, however, try to drop public schema instead like:

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

I found this answer here.