PostgreSQL - Running on macOS
brew install Postgresql
Upgrading can leave the database in a state that can’t be used.
Effect is that the server, when started with
brew services start postgresqlseems to not run.
brew services restart -vvv postgresqlwill list the settings of the install
Log file can be found here (default is
/usr/local/var/log/postgres.log) to give clues if you need to udpdate the database
Can attempt to upgrade with
pid from previuos server could still exist, check log (see above) for location and remove file