Manage user in PostgreSQL

Get in the PostgreSQL console:

sudo -u postgres psql

Create user:

# Create database if don't exist
CREATE DATABASE <database_name>;
CREATE USER <username> WITH PASSWORD '<password>';

Grant privileges:

GRANT ALL PRIVILEGES ON DATABASE <database_name> TO <username>;