stanosmith/fix-postgresql-brew-service-fails-to-start.md

Created May 26, 2022 14:12

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/stanosmith/d1a35a2611b7545a4c559b1f800a07ad.js"></script>
Save stanosmith/d1a35a2611b7545a4c559b1f800a07ad to your computer and use it in GitHub Desktop.

Sometimes the Postgresql Brew service isn't shut down correctly, due to a hard boot or OS crash, and the process id file (postmaster.pid) doesn't get removed.

Raw

fix-postgresql-brew-service-fails-to-start.md

Remove the old postmaster.pid file:

trash /usr/local/var/postgres/postmaster.pid
# or rm /usr/local/var/postgres/postmaster.pid

Restart the postgresql service:

brew services restart postgresql

To use the trash command, install the Trash CLI by Sindre Sorhus.

I found the answer on Stack Overflow: Cannot connect to Postgres server running through brew services