jbothma/pg10-to-9.sh

Last active June 18, 2018 14:08

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

Select an option

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

Download ZIP

Load postgresql 10 dump into postgres 9.3

Raw

pg10-to-9.sh

zcat dump.gz | egrep -v "(idle_in_transaction_session_timeout|row_security|AS integer)" | psql postgresql://...

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