![]() In the terminal, create a new database cluster with /Applications/Postgres.app/Contents/Versions/9.6/bin/initdb -D ~/Library/Application\ Support/Postgres/var-9.6 -encoding=UTF-8 -locale=en_US.UTF-8.Go to ~/Library/Application Support/Postgres and create a new, empty folder for the new data directory, eg var-9.6.If binaries are missing, copy them from a different version of Postgres.app (you can find all supported versions on this page).Navigate to the subdirectory Contents/Versions and make sure that binaries for the old version and the new version are included.Right-Click to “Show Package Contents” on the new Postgres.app.Place the new version of Postgres.app in the /Applications folder.Here’s an example how to upgrade from 9.5 to 9.6: ![]() Postgres.app 2 contains 9.5 and 9.6 by default, but using other versions is possible as well. Since pg_upgrade needs the old and new binaries, you must make sure that Postgres.app contains the binaries of the old server and of the new server. Make sure you completely understand the process and have a working backup before attempting this! This is recommended only if you have a large database and using pg_dump is too slow or uses too much disk space. ![]() Using pg_upgrade from the command line is a bit more difficult.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |