Skip to content

Instantly share code, notes, and snippets.

@booherbg

booherbg/postgres-upgrade.md

Created July 7, 2021 18:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save booherbg/e4e36a9c8584d6c1cd32d41029bb3678 to your computer and use it in GitHub Desktop.
Save booherbg/e4e36a9c8584d6c1cd32d41029bb3678 to your computer and use it in GitHub Desktop.
Download ZIP
Upgrading Postgres from 12 to 13
Raw
postgres-upgrade.md

I have no idea how but postgres was upgraded to 13, but the database was still in 12, so it wouldn't boot.

This URL saved the day: https://quaran.to/Upgrade-PostgreSQL-from-12-to-13-with-Homebrew

brew services stop postgresql
brew postgresql-upgrade-database
./analyze_new_cluster.sh
brew services start postgresql
ps ax | grep postgres
./analyze_new_cluster.sh
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment