Pg_upgrade run on Thu Mar 10 19:51:23 2016Ĭommand: “/usr/local/Cellar/postgresql94/9.4.5/bin/pg_ctl” -w -l “pg_upgrade_server.log” -D “/usr/local/var/postgres” -o “-p 50432 -b -c listen_addresses=” -c unix_socket_permissions=0700 -c unix_socket_directories=’/Users/username/Projects/ProjectName'” start > “pg_upgrade_server.log” 2>&1 Is the server running locally and acceptingĬonnections on Unix domain socket “/Users/username/Projects/ProjectName/.s.PGSQL.50432”?Īnd here’s the log from pg_upgrade_server.log: There were problems executing “”/usr/local/Cellar/postgresql94/9.4.5/bin/pg_ctl” -w -l “pg_upgrade_server.log” -D “/usr/local/var/postgres” -o “-p 50432 -b -c listen_addresses=” -c unix_socket_permissions=0700 -c unix_socket_directories=’/Users/username/Projects/ProjectName'” start > “pg_upgrade_server.log” 2>&1″Ĭonsult the last few lines of “pg_upgrade_server.log” forĬonnection to database failed: could not connect to server: No such file or directory 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.
Brew uninstall postgres install#
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/
Brew uninstall postgres update#
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 kommentar(er)
