While trying to get a local version of issue_stats running, we ran into a problem we previously experienced with respect to using an MD5 password on a Vagrant box.
Since these commands aren't the most trivial, we figure it would be a good idea to document.
Here's how to add a new user to PostgreSQL in Vagrant:
# Set up PostgreSQL 9.3 configuration
# Modified from https://github.com/twolfson/vagrant-nodebugme/blob/1.0.0/bin/bootstrap.sh#L26-L54
# If we can't open `psql` as `vagrant`