Install PostgreSQL 16 and have it work with zsh

https://www.postgresql.org/download/macosx/

I first installed PostgreSQL via HomeBrew, but it installed version 14 when I needed to match a server at version 16. When I installed it again via HomeBrew using brew install postgresql@16, I couldn’t access commands such as psql.

I’m sure there are ways to fix all of these aliases, but I have seen how command line apps silently accumulate (plus I am a pleb). So I went with the application download option.

Going this route does NOT connect with zsh by default.

You’ll need to edit your “/Users/YOUR_USERNAME/.zshrc file and add the following PATH alias at the bottom of the file.

export PATH=$PATH:/Library/PostgreSQL/16/bin

Restart Terminal, and you should be in business.