![]() ![]() For example, when upgrading from 9.3 to 9.4: Since pg_upgrade needs the old and new binaries, you must make a special version of Postgres.app containing both the old and new binaries. 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. Now use psql or pg_restore to restore the dump file.Quit the old version of Postgres.app, then start the new version of Postgres.app.While the old version is running, use pg_dump (or pg_dumpall if you have multiple databases) to create a dump of your database.This is the recommended way for migrating your data. There are two ways to migrate the data: Migrate data using pg_dump You are responsible for migrating the data yourself. 9.3.x to 9.4.x), Postgres.app will create a new, empty data directory. When updating between minor PostgreSQL releases (eg. 9.3.0.0 → 9.3.1.0 or 9.3.1.0 → 9.3.1.1) is as simple as replacing Postgres.app in your Applications directory (just be sure to quit the app first, though). Starting with Version 9.2.2.0, Postgres.app is using semantic versioning, tied to the release of PostgreSQL provided in the release, with the final number corresponding to the individual releases of Postgres.app for each distribution. Default data directory: ~/Library/Application Support/Postgres/var-9.3.Shared Libraries: /Applications/Postgres.app/Contents/Versions/9.3/share.Libraries: /Applications/Postgres.app/Contents/Versions/9.3/lib.Headers: /Applications/Postgres.app/Contents/Versions/9.3/include.Binaries: /Applications/Postgres.app/Contents/Versions/9.3/bin.If you'd like to use the command line tools delivered with Postgres.app, see the section on Command Line Tools. On first launch, Postgres will initialise a new database cluster and create a database for your username.Ī few moments after launching, you should be able to click on "Open psql" to connect to the database. To install Postgres.app, just drag it to your Applications folder and double click. Installing, Upgrading and Uninstalling Postgres.app Installing Postgres.app ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |