Fixing PostgreSQL after Homebrew upgraded it from 9.1 to 9.2 and I was suddenly unable to access my existing databases

July 3, 2013
programming postgresql homebrew osx


  • You just rebooted and suddenly PostgreSQL isn’t responding
  • Restarting postgres fails due to a “Your data files are incompatible with the current version of Postgres” error.


There’s a utility that comes with Postgres named pg_upgrade which should sort you out. In order to work it you’ll need to create and initialize a new postgres data directory and then call pg_upgrade and pass it paths for the old binaries, new binaries, old data directory, and new data directory. Read the script below for an example.