Skip to content

Instantly share code, notes, and snippets.

@mlr

mlr/PostgreSQL-README.md

Last active December 2, 2022 19:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mlr/2831a383138771e4ff60f1631fdcfa6e to your computer and use it in GitHub Desktop.
Save mlr/2831a383138771e4ff60f1631fdcfa6e to your computer and use it in GitHub Desktop.
Download ZIP
Start PostgreSQL mac
Raw
PostgreSQL-README.md

Sometimes restart can leave PostgreSQL not running.

tail -n 100 /usr/local/var/log/postgresql@9.6.log

FATAL: lock file "postmaster.pid" already exists HINT: Is another postmaster (PID 470) running in data directory "/usr/local/var/postgresql@9.6"?

rm /usr/local/var/postgresql@9.6/postmaster.pid
sudo brew services restart postgresql@9.6

Should be started successfully.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment