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

Question

I am having PostgreSQL 10.1 in my Mac, and I want 9.6 for my work website to function on my local machine. Could not get any clear instructions on how to uninstall or downgrade to 9.6.

Can anyone help with this?

Answer 1

I got this problem as well after running the brew upgrade. 

Following commands worked for me:

brew uninstall postgresql
brew install postgresql@9.6
brew services start postgresql@9.6
brew link postgresql@9.6 --force

Are you interested to know SQL in detail? Come and join the SQL Certification course to gain more knowledge.