If you created a database by mistake you can remove it. For details refer to the PostgreSQL manual:
dropdb
DROP DATABASE