Gross script to whack all pg data and make a fresh DB

fresh-db.sh

#!/usr/bin/env bash

set -o errexit
set -o pipefail
[[ "${DEBUG}" == 'true' ]] && set -o xtrace

brew services stop postgresql@12
rm -rf /usr/local/var/postgresql\@12/
initdb -E utf8 -U postgres /usr/local/var/postgresql\@12/

sleep 5

psql -v ON_ERROR_STOP=1 -U postgres <<-EOSQL
  CREATE USER "foo" WITH PASSWORD 'foo';
  CREATE DATABASE "foo";
  GRANT ALL PRIVILEGES ON DATABASE "foo" TO "foo";
EOSQL