Skip to content

Instantly share code, notes, and snippets.

@scottweisman

scottweisman/postgres-upgrade.md

Last active August 29, 2015 14:08
Show Gist options
  • Save scottweisman/537588481550a0e8770b to your computer and use it in GitHub Desktop.
Save scottweisman/537588481550a0e8770b to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade Postgress.app
Raw
postgres-upgrade.md

Update Postgres or Mac OS without losing local databases

  1. Dump all databases: $ pg_dumpall > db.out

  2. Delete current postgres.app

  3. Download & install new posgres.app

  4. Reload database: $ psql -f db.out postgres

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