brew install postgresql@11 creates a broken link to icu4c on Ventura

[Ngalstyan4]

Output of brew config

bash-3.2$ brew config
HOMEBREW_VERSION: 4.2.16-95-g9bd0367
ORIGIN: https://github.com/Homebrew/brew
HEAD: 9bd03675f6cd0140e4dfad568efe58dc2224070e
Last commit: 9 hours ago
Core tap HEAD: c8a728b18777e96b6143cd04fcd3b4101dca7df7
Core tap last commit: 3 hours ago
Core tap JSON: 05 Apr 04:20 UTC
Core cask tap HEAD: c9fa8607bd3e66dfb27bb53a3abed02adc06fb01
Core cask tap last commit: 49 minutes ago
Core cask tap JSON: 05 Apr 04:20 UTC
HOMEBREW_PREFIX: /usr/local
HOMEBREW_CASK_OPTS: ["--no-quarantine"]
HOMEBREW_COLOR: set
HOMEBREW_CURLRC: 1
HOMEBREW_GITHUB_API_TOKEN: set
HOMEBREW_MAKE_JOBS: 4
HOMEBREW_NO_AUTO_UPDATE: set
HOMEBREW_NO_INSTALL_CLEANUP: set
HOMEBREW_SORBET_RUNTIME: set
Homebrew Ruby: 3.1.4 => /usr/local/Homebrew/Library/Homebrew/vendor/portable-ruby/3.1.4/bin/ruby
CPU: quad-core 64-bit ivybridge
Clang: 15.0.0 build 1500
Git: 2.44.0 => /usr/local/bin/git
Curl: 8.4.0 => /usr/bin/curl
macOS: 13.6.6-x86_64
CLT: 14.3.1.0.1.1683849156
Xcode: 15.0.1 => /Applications/Xcode_15.0.1.app/Contents/Develope

Output of brew doctor

bash-3.2$ brew doctor
Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  [email protected]
  packer
  postgresql@11

Description of issue

I know postgresql@11 has recently reached EOL so not sure this would be fixed, but I ran into this in CI/CD and came here to share:

brew install postgresql@11
brew services start  postgresql@11

Fails with the following in postgresql logs:

dyld[35684]: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.73.dylib
  Referenced from: <F171B30A-2F7C-3F89-8E76-DAF107255C24> /usr/local/Cellar/postgresql@11/11.22_1/bin/postgres
  Reason: tried: '/usr/local/opt/icu4c/lib/libicui18n.73.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/icu4c/lib/libicui18n.73.dylib' (no such file), '/usr/local/opt/icu4c/lib/libicui18n.73.dylib' (no such file), '/usr/local/lib/libicui18n.73.dylib' (no such file), '/usr/lib/libicui18n.73.dylib' (no such file, not in dyld cache), '/usr/local/Cellar/icu4c/74.2/lib/libicui18n.73.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/icu4c/74.2/lib/libicui18n.73.dylib' (no such file), '/usr/local/Cellar/icu4c/74.2/lib/libicui18n.73.dylib' (no such file), '/usr/local/lib/libicui18n.73.dylib' (no such file), '/usr/lib/libicui18n.73.dylib' (no such file, not in dyld cache)

output of audit

bash-3.2$  brew audit postgresql@11
Broken dependencies:
  /usr/local/opt/icu4c/lib/libicui18n.73.dylib (icu4c)
  /usr/local/opt/icu4c/lib/libicuuc.73.dylib (icu4c)
postgresql@11
  * postgresql@11 has broken dynamic library links:

    Rebuild this from source with:
      brew reinstall --build-from-source postgresql@11
    If that's successful, file an issue here:
      https://github.com/Homebrew/homebrew-core/issues
Error: 1 problem in 1 formula detected.

it seems icu4c has been updated to 74.2 but the symlink in postgres was not updated to
/usr/local/Cellar/icu4c/74.2/lib/libicui18n.74.2.dylib

[ZhongRuoyu]

postgresql@11 was already deprecated when icu4c was updated to a newer version, so it was not tested nor rebuilt. Please consider migrating to a newer, supported version instead.

[Headmaster11]

brew upgrade helped me