Postgres – FATAL: database files are incompatible with server

by

If you recently upgraded postgres to latest version, you can run the below command to upgrade your postgres data directory retaining all data:

brew postgresql-upgrade-database

The above command is taken from the output of brew info postgres

Note: this won’t work for upgrading from 14 to 15 as of recent testing.

More Related Contents:

  1. How can I start PostgreSQL server on Mac OS X?
  2. `pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)
  3. Homebrew refusing to link OpenSSL
  4. How to install latest version of openssl Mac OS X El Capitan
  5. Update OpenSSL on OS X with Homebrew
  6. How to fix homebrew permissions?
  7. psql: FATAL: role “postgres” does not exist
  8. Postgres could not connect to server
  9. dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
  10. psql: could not connect to server: No such file or directory (Mac OS X)
  11. How to use GNU sed on Mac OS 10.10+, ‘brew install –default-names’ no longer supported
  12. Brew doctor says: “Warning: /usr/local/include isn’t writable.”
  13. Error: Cannot install in Homebrew on ARM processor in Intel default prefix (/usr/local)
  14. How to run the Homebrew installer under Rosetta 2 on M1 Macbook
  15. Uninstall / remove a Homebrew package including all its dependencies
  16. PDFtk Server on OS X 10.11
  17. Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
  18. Error: The ‘brew link’ step did not complete successfully
  19. Installing Homebrew on macOS
  20. What is the best/safest way to reinstall Homebrew?
  21. Using Homebrew with alternate GCC
  22. Docker & Postgres: Failed to bind tcp 0.0.0.0:5432 address already in use
  23. Stuck at “.android/repositories.cfg could not be loaded.”
  24. Setting environment variables on OS X
  25. Upgrade Node.js to the latest version on Mac OS
  26. How to use the php that brew installed?
  27. Battery status API in macOS?
  28. Mac OS: /usr/bin/env: bad interpreter: Operation not permitted
  29. Where to find extensions installed folder for Google Chrome on Mac?
  30. Updating Make Version on Mac

Leave a Comment