Postgres on macos or OSX - Fix

gistfile1.sh

# ** ERROR 1 **
# FATAL:  lock file "postmaster.pid" already exists
# HINT:  Is another postmaster (PID 4646) running in data directory "/usr/local/var/postgres"?
#
# ** ERROR 2 **
# Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
#
# To fix one of this errors:

cat /usr/local/var/postgres/postmaster.pid # pid is the number on first line
kill -9 1116 # replace 1116 with pid number (first line) from postmaster.pid file

# Or

pg_ctl -D /usr/local/var/postgres stop
pg_ctl -D /usr/local/var/postgres start

# Or

cd /usr/local/var/postgres
mv postmaster.pid postmaster.backup
pg_ctl -D /usr/local/var/postgres start
rm postmaster.backup

awesome, thanks

yes thank you, this was helpful!

Thanks!

Thaank you!! Very, very helpful!! :)

Thanks!

I have other problem. I've tried this
"pg_ctl -D /Library/PostgreSQL/9.3/bin/postgres start"
and I got
pg_ctl: could not open PID file "/Library/PostgreSQL/9.3/bin/postgres/postmaster.pid": Not a directory

Please help...