Create New User and New Database for the PostgreSQL

create_new_user_and_new_db.sql

CREATE ROLE new_user WITH LOGIN PASSWORD 'your_secure_password';
CREATE DATABASE new_database OWNER new_user;
GRANT ALL PRIVILEGES ON DATABASE new_database TO new_user;

-- Example:
-- CREATE ROLE talking_book WITH LOGIN PASSWORD 'your_secure_password';
-- CREATE DATABASE think_and_grow_rich OWNER talking_book;
-- GRANT ALL PRIVILEGES ON DATABASE think_and_grow_rich TO talking_book;
-- #psql -U talking_book -d think_and_grow_rich

-- To forcefully drop it—even with active connections
DROP DATABASE new_database WITH (FORCE);