![]() POSTGRES APP VS PSEQUEL FOR MACI’ve been looking a long time for a Postgres client for Mac that will be even a fraction of what Sequel Pro is for MySQL. Step -3 - Reopen the Postgres.app let it rebuild the directory and start again from Step 7 in the guide.Step -2 - Delete the ~/Library/Containers//Data/Library/Application\ Support/Postgres/var directory. POSTGRES APP VS PSEQUEL UPGRADEThis is what I did whenever I had issues during the upgrade process and needed a hard-reset. delete_old_cluster.sh to remove the old 9.2 data and delete the old Postgres.app from your desktop. analyze_new_cluster.sh to get your DB ready for business Step 14 - Let the upgrade command run, once it’s finished successfully it will print out Upgrade Complete.new-bindir /Applications/Postgres.app/Contents/MacOS/bin old-bindir ~/Desktop/Postgres.app/Contents/MacOS/bin \ new-datadir ~/Library/Containers//Data/Library/Application\ Support/Postgres/var \ Pg_upgrade -old-datadir ~/Library/Application\ Support/Postgres/var \ Step 13 - In the terminal run the following command making sure that all the locations are correct.Step 10 - Run DROP DATABASE username (replace username with your username) to remove your user’s database.This is necessarily since you can’t drop the database you are currently in (see next step). Step 9 - Run \c postgres to move to the postgres database from your user’s database.You should have 4 databases: postgres, 2 templates and one database for your username. Step 8 - In the psql run \l to get a list of databases.Step 7 - Run psql and connect to the DB.Step 6 - Move the newly downloaded Postgres.app to /Applications and launch it.Step 5 - Copy your old 9.2 Postgres.app from /Applications to your desktop.Step 4 - Close the Postgres.app if it’s currently running.Step 3 - Download the new Postgres.app.Step 2 - Open a new terminal window and run which psql it should point to /Applications/Postgres.app/Contents/MacOS/bin/psql - If it doesn’t check Step 0 again.zshrc (which ever you use) PATH="/Applications/Postgres.app/Contents/MacOS/bin:$PATH" Step 1 - Make sure your PG binaries are linked correctly into your PATH and that you’ll be using the correct psql and pg_upgrade commands by checking that the following line appears in your.So I wrote this short step by step guide to help you upgrade your database without losing all the data you already have there. I love Postgres.app it really is the quickest and easiest way to get a postgres database running on your mac.īut I just had some bad time upgrading from Postgres.app 9.2 to 9.3. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |