aka: Document Solution or you will repeat the search
March 1, 2017
Dear Future Self,
You got this message again?
Yes, you have see it before.
Here's steps to debug:
Check that the PID isn't still running and kill -9 it if running
ps auxwww | grep postgres - no processes running
pg_ctl -D /usr/local/var/postgres status - Checks the status of the server
kill -9 *PID NUMBER*
Didn't work? Postgres's setup and/or configuration could be corrupted so brew will remove the old setup, overwrite any corrupted files or paths, and then install postgres, link it, and start the service.
brew uninstall postgres
brew install postgres
brew postinstall postgresql
brew link postgresql or brew link --overwrite postgresql
brew services start postgresql
Update if other errors or solutions are found or else you will pay.