zf-fww
Last Updated: April 18, 2016
·
22.32K
· jasontorres
3af261e4328c1610e1cd563d067f276b

Postgres on OSX with homebrew not running after OSX crash

OSX Mavericks has been crashing randomly recent to me. Just very random. Not quite good because it doesn't give it the chance for processes like Postgres, etc... to shut down properly, leaving process ids (PIDs) behind.

Now got this issue where my postgres won't boot up.

Running postgres manually doesn't work

> pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
> pg_ctl: another server might be running; trying to start server anyway

So here's a quick fix.

1) Check the log

$ tail -f /usr/local/var/postgres/server.log
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 326) running in data directory "/usr/local/var/postgres"?
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 326) running in data directory "/usr/local/var/postgres"?

2) Delete the PID file.

$ rm /usr/local/var/postgres/postmaster.pid

3) Run pg_ctl manually

$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

4) Make sure it's running

$ ps x | grep postgres

This should appear from the output above

8352   ??  S      0:00.02 /usr/local/opt/postgresql/bin/postgres -D /usr/local/var/postgres -r /usr/local/var/postgres/server.log
8354   ??  Ss     0:00.00 postgres: checkpointer process
8355   ??  Ss     0:00.03 postgres: writer process
8356   ??  Ss     0:00.01 postgres: wal writer process
8357   ??  Ss     0:00.00 postgres: autovacuum launcher process
8358   ??  Ss     0:00.00 postgres: stats collector process

Also, this also happens to other processes like mongodb or anything that relies on PID files.

Say Thanks
Respond

8 Responses
Add your response

17229
2014 06 28 chopada med pesqueiro squared

Thx, saved my life.

over 1 year ago ·
17962
Qygjikj3 normal

how to make it permanent? so i won't have to repeat this process each time i start the terminal :/

over 1 year ago ·
18121
None

+1 Thanks!

over 1 year ago ·
18235
06fb2be8d4434528e242e0d26288cc1d

Many thanks!

over 1 year ago ·
18343
4e1c874c21baa8f0cac5d61a9dcb8374

Yeah this is super annoying, i guess I need to write a bash script that deletes postmaster.pid and restarts postgres after sleeping.

over 1 year ago ·
20742
None

Thanks a lot for this post. Saved me a few times. BTW, if you are using launchctl you only need to delete the postmaster.pid file and the rest will take care of itself.

over 1 year ago ·
23255
None
over 1 year ago ·
24610
None

Thank you !

over 1 year ago ·