PosgreSQL on Debian

There is an instance of PostgreSQL running on the orca VM. Here are some pointers on working with it (taken from the Debian PostgreSql page).

Create a new user

sudo su - postgres
createuser --pwprompt <user>

Create a new database

sudo su - postgres
createdb -O <user> <database>