B /usr/local/Cellar/postgresql/9.5.1/bin/ -vīut running into the following error in Terminal: I went ahead and re-installed 9.4.5 binary, then switched back to 9.5.1 and am now trying to run pg_upgrade with this command: I was running 9.4.*, and then accidentally re-installed Homebrew (as a result of working on a another project and not thinking), which auto-installed postgres 9.5.1. Wondering if someone here can help me, I somehow borked my postgres db last night. Note 2: If you’ve already uninstalled a previous version of PostgreSQL, there is a good post on StackOverflow with instructions to install previous versions. Note: If you’re using the pg gem for Rails, you should recompile: $ gem uninstall pg $ mv /usr/local/var/postgres9.5 /usr/local/var/postgres $ mv /usr/local/var/postgres /usr/local/var/postgres9.4 Move 9.5 data directory back to where PostgreSQL expects it to be:.B /usr/local/Cellar/postgresql/9.5.0/bin/ \ Replace 9.4.5_2 with the most current version of postgres in that directory. Note that I have 9.4.5_2 in here, it could be that you aren’t on the latest version. Migrate the data to the new 9.5 database.$ initdb /usr/local/var/postgres9.5 -E utf8 # or, if you're running a current version of Homebrew $ launchctl unload ~/Library/LaunchAgents/ I wrote a post about upgrading from 9.3 to 9.4 in the past, and many people found it useful, so I decided to update it a bit for the 9.4 to 9.5 upgrade. I also have a guide using pg_upgradecluster on Ubuntu. 30 2016: PostgreSQL 9.6 was released today, and these instructions should work - just replace 9.4 with 9.5 and 9.5 with 9.6.
0 Comments
Leave a Reply. |