Stop your running postgres server (your plist name may or may not have specified the version in it, mine had 94 in the name)
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql94.plist
Upgrade to 9.6
brew update && brew upgrade postgresql
Check your version