homebrew postgresql

install.sh

#!/bin/sh

brew install postgresql
brew services start postgresql
createdb `whoami`
# https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist
psql # to test login works

createuser -s postgres
psql -U postgres # to test login works

# https://blog.testdouble.com/posts/2021-01-28-how-to-completely-uninstall-homebrew-postgres/
brew uninstall postgres
rm -rf /usr/local/var/postgres
rm /usr/local/var/log/postgres.log
rm -f ~/.psqlrc ~/.psql_history