Skip to content

Instantly share code, notes, and snippets.

@Keita-N
Created April 17, 2017 07:04
Show Gist options
  • Save Keita-N/0e277b811f74ae46ce94aef63ce406d7 to your computer and use it in GitHub Desktop.
Save Keita-N/0e277b811f74ae46ce94aef63ce406d7 to your computer and use it in GitHub Desktop.
postgreql upgrade 9.5 -> 9.6
brew info postgresql
```
/usr/local/Cellar/postgresql/9.5.4 (3,147 files, 35MB)
Poured from bottle on 2016-09-05 at 10:59:38
/usr/local/Cellar/postgresql/9.6.2 (3,251 files, 36.5MB) *
Poured from bottle on 2017-03-13 at 13:20:21
```
mkdir /usr/local/var/postgres9.6.2
initdb -D /usr/local/var/postgres9.6.2/
pg_upgrade -d /usr/local/var/postgres -D /usr/local/var/postgres9.6.2/ -b /usr/local/Cellar/postgresql/9.5.4/bin/ -B /usr/local/Cellar/postgresql/9.6.2/bin/ -v
export PGDATA="/usr/local/var/postgres9.6.2"
pg_ctl start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment