crmaxx/migrate.md

Last active August 12, 2021 13:46

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/crmaxx/0de630765f95701873422dca139bb92a.js"></script>
Save crmaxx/0de630765f95701873422dca139bb92a to your computer and use it in GitHub Desktop.

PG migrate 11 to 13

Raw

    λ ~  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


  