restart postgres
start server
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
brew info postgres
Or, if you don't want/need launchctl, you can just run:
postgres -D /usr/local/var/postgres
shutdown
pg_ctl restart -D /usr/local/var/postgres