Postgres Setup

setup_postgres.sh

# install postgres
sudo apt update
sudo apt install postgresql postgresql-contrib libpq-dev

# login as postgres user
sudo -i -u postgres

# log into psql shell
psql

# set password
> \password

# enter in password and then confirmation

# quit
> \q

# update postgres login config
sudo vi /etc/postgresql/10/main/pg_hba.conf

# comment out peer and add in password
# comment out this one
# local   all             postgres                                peer
# add this line
# local   all             postgres                                password

# restart
sudo service postgresql restart