postgresql.md

Connect with command line

sudo -i -u postgres # change user 
psql # connect to postgresql

Commnands

# List all users
\du

# Change user password
ALTER USER username WITH PASSWORD 'newpassword';

# To allow an user create a database
ALTER USER username CREATEDB;