When we want to delete a database it is recommended to do it using the web/database/manager.
When we delete it from postgres there are remaining files hosted in the following location /home/odoo/.local/share/Odoo and they may interfer with the correct installation of the new database.
This path can be configured on the config file using the parameter data_dir.
It includes the following folders sessions, addons y filestore.