Create a new role/user and database, then assign the user into the database in postgres

postgres-new-user-and-database.txt

# Create a new user on linux first
>> adduser aditya

# Change the password
>> passwd aditya

# Login as root and go into psql
>> su - root

# Login as postgres user
>> su - postgres

# Try psql, we will go into postgres sql console
>> psql

# Create a new user in postgres
>> CREATE USER codeslave WITH PASSWORD 'aditya';
CREATE ROLE

# Create a new database
>> CREATE DATABASE buntutkacang;
CREATE DATABASE

# Make grant all access for user 'aditya'
>> GRANT ALL PRIVILEGES ON DATABASE buntutkacang TO aditya;
GRANT

# See the result
>> \l

# Quit
>> \q