Shermans's Notes
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  1. Sherman's notes
  2. /
  3. Knowledge
  4. /
  5. Databases
  6. /
  7. PostgreSQL
  8. /
  9. PostgreSQL - Running on macOS

PostgreSQL - Running on macOS

Postgresql

Install

  • brew install Postgresql

Issues

  • Upgrading can leave the database in a state that can’t be used.

  • Effect is that the server, when started with brew services start postgresql seems to not run.

  • brew services restart -vvv postgresql will 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 brew postgresql-upgrade-database

  • pid from previuos server could still exist, check log (see above) for location and remove file