Skip to content

Instantly share code, notes, and snippets.

@crmaxx

crmaxx/migrate.md

Last active August 12, 2021 13:46
Show Gist options
  • Save crmaxx/0de630765f95701873422dca139bb92a to your computer and use it in GitHub Desktop.
Save crmaxx/0de630765f95701873422dca139bb92a to your computer and use it in GitHub Desktop.
Download ZIP
PG migrate 11 to 13
Raw
migrate.md 
λ ~  rm -rf /usr/local/var/postgres
λ ~  initdb --locale=en_US.UTF-8 -E UTF-8 /usr/local/var/postgres

λ ~  /usr/local/bin/pg_upgrade --old-datadir /usr/local/var/postgresql@11 \
			       --new-datadir /usr/local/var/postgres \
			       --old-bindir /usr/local/opt/postgresql@11/bin \
			       --new-bindir /usr/local/opt/postgresql@13/bin
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment