Skip to content

Instantly share code, notes, and snippets.

@joho
Forked from rafaelss/gist:3700977
Created September 17, 2012 05:40
Show Gist options
  • Save joho/3735740 to your computer and use it in GitHub Desktop.
Save joho/3735740 to your computer and use it in GitHub Desktop.
PostgreSQL 9.2 upgrade steps
Steps to install and run PostgreSQL 9.2 using Homebrew (Mac OS X)
(if you aren't using version 9.1.5, change line 6 with the correct version)
1. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
2. mv /usr/local/var/postgres /usr/local/var/postgres91
3. brew update
4. brew upgrade postgresql
5. initdb /usr/local/var/postgres -E utf8
6. pg_upgrade -b /usr/local/Cellar/postgresql/9.1.5/bin -B /usr/local/Cellar/postgresql/9.2.0/bin -d /usr/local/var/postgres91 -D /usr/local/var/postgres
7. cp /usr/local/Cellar/postgresql/9.2.0/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
8. pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
If you're using ruby, also:
gem pristine pg
@krisdigital
Copy link

Thanks!

@AntonTrapp
Copy link

Thanks! Just updated 9.4 to 9.5.2 without any problems, just had to change the version numbers :)

@Xosmond
Copy link

Xosmond commented Jun 10, 2016

Great, works to upgrade from 9.4.5 to 9.5.3

@mgidea
Copy link

mgidea commented Dec 2, 2016

Thanks! worked great upgrading from 9.4.1 to 9.6.1

@delef
Copy link

delef commented Dec 6, 2016

Thanks, works to upgrade from 9.5.3 to 9.6.1

@giles-cholmondley-durston

Worked 1st time, thanks! 9.5.4 to 9.6.1.

@mostlydev
Copy link

👍 Me too. This is getting repetitive, but the repetitive thanks are well earned.

@haukelicht
Copy link

Worked for 9.5.3 to 9.6.2 - Thanks!

@crogersdev
Copy link

crogersdev commented Dec 26, 2017

👍

Going from 9.6 to 10.1 on macOS (10.13.1) I had to specify the new local cluster storage for the pg_upgrade call on step 6. To wit:

$ pg_upgrade -b /usr/local/Cellar/postgresql/9.6.3/bin -B /usr/local/Cellar/postgresql/10.1/bin -d /usr/local/var/postgres96 -D /usr/local/var/postgres

@morriskimani
Copy link

Thank you for this. Saved me a lot of time.

@emil-alexandrescu
Copy link

Thanks! Worked like charm when I upgrade from 9.6.5 to 10.1.

@JocelynTriplett
Copy link

Thanks so much for this!

@skywalker19
Copy link

Thanks.. also work when upgrading 12 to 14

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment