Too long don't read
I wanted to upgrade some things through HomeBrew, but it seems like it broke my Postgres.
I'm on MacOS. I need to be able to run my Postgres again. Deleting without backups isn't much of a problem: this is a local dev setup.
Long sequence of operations for upgrading and debugging
I ran:
brew update
brew upgrade
Which output:
==> Upgrading 10 outdated packages:
postgresql 13.3 -> 14.1_1
==> Upgrading postgresql
13.3 -> 14.1_1
==> Pouring postgresql--14.1_1.monterey.bottle.tar.gz
==> Caveats
To migrate existing data from a previous major version of PostgreSQL run:
brew postgresql-upgrade-database
This formula has created a default database cluster with:
initdb --locale=C -E UTF-8 /usr/local/var/postgres
For more details, read:
https://www.postgresql.org/docs/14/app-initdb.html
To restart postgresql after an upgrade:
brew services restart postgresql
Or, if you don't want/need a background service you can just run:
/usr/local/opt/postgresql/bin/postgres -D /usr/local/var/postgres
==> Summary