Home > Net >  Broken psql from brew upgrade postgresql
Broken psql from brew upgrade postgresql

Time:12-11

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
           
  • Related