Setup postgres in Ubuntu

setup-postgres.sh

# Install postgres
sudo apt update
sudo apt install postgresql postgresql-contrib

# Switch to your postgres account/user
sudo -i -u postgres

psql 
OR
sudo -u postgres psql

# Create new role
sudo -u postgres createuser --interactive
Enter name of role to add: myUserName
Shall the new role be a superuser? (y/n) y

# Create new database
sudo -u postgres createdb

# Change default passwords
\password