I rarely ever reboot my Mac. It sits on my desk loyally waiting for my next command ready to respond to my every whim.
However, on occasion, something happens and it does need a reboot.
Today was one of those days. Upon reboot everything appeared fine until I tried to work on some code. PostGreSQL was dead.
This isn’t the first time this has happened to me and I’m guessing it won’t be the last so for the benefit of all here’s
Here’s the error I get:
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
The trick is to look at the logs. I installed using Homebrew so my logs are here:
I had done a hard reboot which left ‘postmaster.pid’ in place:
I removed that file and then started up PostGres with:
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
Now I’m good to go.