I’m glad you got it working!
Just wanted to mention for MacOS there is Postgres.app https://postgresapp.com as an option. I used the homebrew Postgres a few years ago but ran into difficulties getting the PostGIS extension installed and stable through updates.
After going down a major rabbit hole I found this app which makes it dead simple to run multiple versions of Postgres including PostGIS simultaneously on different port numbers in development.
And of course many prefer using Docker Compose to run PG in development isolating the dev environment but I don’t mind having system-wide Postgres.app running supporting all my apps.
