Update brew and upgrade old packages.
brew update && brew upgrade
After running pg_ctl -D /usr/local/var/postgres restart i get message.
The data directory was initialized by PostgreSQL version 11, which is not compatible with this version 12.4.
So we need upgrade old data to new version..
After upgrade postgresql v 11 has be gone. Install missing postgres version.
brew install [email protected]
Create backup from old data.
mv /usr/local/var/postgres /usr/local/var/postgres.old
Init new database with correct encoding and locale.
initdb -E UTF8 --locale=C /usr/local/var/postgres/
Run database upgrade
pg_upgrade -b /usr/local/Cellar/[email protected]/11.9/bin -B /usr/local/Cellar/postgresql/12.4/bin/ -d /usr/local/var/postgres.old -D /usr/local/var/postgres