Skip to content

Instantly share code, notes, and snippets.

@okwrtdsh

okwrtdsh/PostgreSQL944to952.md

Last active April 26, 2016 15:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save okwrtdsh/b027fbb01cf8996eeb08765317fbe28b to your computer and use it in GitHub Desktop.
Save okwrtdsh/b027fbb01cf8996eeb08765317fbe28b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PostgreSQL944to952.md

PostgreSQL9.4.4 to 9.5.2

参考

https://gist.github.com/joho/3735740

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
  9. rm -rf /usr/local/var/postgres91

If you're using ruby, also:

gem pristine pg

pgAdminを最新版に

http://www.pgadmin.org/download/

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