Last active
April 3, 2018 08:36
-
-
Save vlado/1877457 to your computer and use it in GitHub Desktop.
Postgres on macos or OSX - Fix
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ** 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 |
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...
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thanks!