More than 5 years have passed since last update.

9.4への更新

homebrew
PostgreSQL

Posted at 2014-12-22

brew upgradeしたところ、最新版の9.4に更新されました。
DB形式が9.3のままでは、起動しないないので、pg_upgradeします。

$ cd /usr/local/var
$ mkdir postgres94
$ initdb postgres94 -E utf8
$ pg_upgrade \
  -d /usr/local/var/postgres \
  -D /usr/local/var/postgres94 \
  -b /usr/local/Cellar/postgresql/9.3.5_1/bin/ \
  -B /usr/local/Cellar/postgresql/9.4.0/bin/ \
  -v
$ mv /usr/local/var/postgres /usr/local/var/postgres93
$ mv /usr/local/var/postgres94 /usr/local/var/postgres
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up