Due to new upgrade on Mac, my psql server was failing to start due to some mismatch with icu4c version. Here's what I did to fix it.

Impacting services

  • PHP
  • PostgreSQL

Error While Running psql

dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
 Referenced from: /usr/local/Cellar/postgresql/11.3/lib/libpq.5.11.dylib

[1]  40974 abort   psql

Error While tried to switch to another icu4c

$ brew switch icu4c 64.2

Error: icu4c does not have a version "64.2" in the Cellar.
icu4c's installed versions: 67.1

Solution For icu4c

brew update && brew upgrade

During the upgrade you some operation has failed, something like

Error: Could not remove [email protected] keg! Do so manually:
 sudo rm -rf /usr/local/Cellar/[email protected]/7.2.18

In this case, follow the command given and re-run the command

sudo rm -rf /usr/local/Cellar/[email protected]/7.2.18
brew update && brew upgrade

At this point, my database encountered with new error.