PostgreSQL Create new user with database

psql.md

sudo vim /etc/postgresql/12/main/pg_hba.conf

host    <db_name>             <user_name>             0.0.0.0/0               password

:wq

sudo -u postgres psql

CREATE DATABASE <db_name>;
CREATE USER <user_name> WITH ENCRYPTED PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE <db_name> TO <user_name>;
SELECT pg_reload_conf();