Postgresql installed through Brew does not start automatically

Question

Story:

I installed postgresql using brew a while ago, but I haven't found a solution that it would start automatically on the startup. Do you have any solution?

Issue:

this is what I see when I try to connect to local database.

What I've tried:

This is $ brew services list output (single line)

postgresql started root /Library/LaunchDaemons/homebrew.mxcl.postgresql.plist

When installed, I followed instructions to start it now and after restart at login

Workaround:

Only workaround is to run this line

pg_ctl -D /usr/local/var/postgres start which is quite inconvenient since I have to look it up in info page or assign to alias which I can't remember each time when I restart the computer.

Have you tried brew services start postgresql? That should automatically start the service after a restart. — jdno
– jdno, Commented Apr 19, 2018 at 8:16
@jdno yes, this is the command that added the row to the services list. Tried both with and without sudo. — Rozkalns
– Rozkalns, Commented Apr 19, 2018 at 8:41

Allan Mogusu · Accepted Answer · 2019-06-10 14:50:45Z

3

I realized most of these issues when my mac shutdown. To solve this, you may try this:

On your terminal run: postgres -D /usr/local/var/postgres
Copy the PID returned and then run; kill -9 <PID>
Finally, run brew services restart postgres. That should do it for most of the cases

answered Jun 10, 2019 at 14:50

Allan Mogusu

2402 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql installed through Brew does not start automatically

Story:

Issue:

What I've tried:

Workaround:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Story:

Issue:

What I've tried:

Workaround:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related