How to use homebrew to downgrade postgresql from 10.1 to 9.6 on Mac OS

macos postgresql downgrade
SokrateeS picture SokrateeS · Nov 14, 2017 · Viewed 35.2k times · Source

My mac has postgresql 10.1 on it, and I need 9.6 for my work website to function on my local machine. Can't find easy instructions on how to uninstall or downgrade to 9.6. Any help would be appreciated!

Answer

Martin Zinovsky picture Martin Zinovsky · Dec 5, 2017

I got this issue as well after running brew upgrade. Following commands worked for me:

brew uninstall postgresql
brew install [email protected]
brew services start [email protected]
brew link [email protected] --force

Related questions

How can I start PostgreSQL server on Mac OS X?

Final update: I had forgotten to run the initdb command. By running this command ps auxwww | grep postgres I see that postgres is not running > ps auxwww | grep postgres remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres This raises the question: …

Read More
psql: FATAL: role "postgres" does not exist

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I accidentally dropped the postgres database. I don't know what was in it. I'm currently working on a tutorial: http://…

Read More
Postgres could not connect to server

After I did brew update and brew upgrade, my postgres got some problem. I tried to uninstall postgres and install again, but it didn't work as well. This is the error message.(I also got this error message when I …

Read More