Skip to content

Instantly share code, notes, and snippets.

View raphi's full-sized avatar

raphi raphi

26 followers · 8 following
View GitHub Profile
@raphi
raphi / migrate_postgresql_database.md
Created November 3, 2017 10:51 — forked from olivierlacan/migrate_postgresql_database.md
How to migrate a Homebrew-installed PostgreSQL database to a new major version (9.3 to 9.4) on OS X

This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.

First let's check something.

brew info postgresql

The top of what gets printed as a result is the most important: