Postgres DigitalOcean Basic Setup

apt-get update apt-get upgrade apt-get install postgres postgres-contrib

Assume the identity of postgres sudo -i -u postgres

Create a user role for postgres, interactively sudo -u postgres create user –interactive

sudo -u postgres createdb cloudcowboy

sudo adduser cloudcowboy

sudo -i -u cloudcowboy psql