Postgres could not connect to server

by

Had a similar problem; a pid file was blocking postgres from starting up. To fix it:

$ rm /usr/local/var/postgres/postmaster.pid
$ brew services restart postgresql

and then all is well.

UPDATE:

For Apple M1 (Big Sur) users, do this instead:

$ rm /opt/homebrew/var/postgres/postmaster.pid
$ brew services restart postgresql

More Related Contents:

  1. PG::ConnectionBad – could not connect to server: Connection refused
  2. Can not connect to local PostgreSQL
  3. Rails: Installing PG gem on OS X – failure to build native extension
  4. Repairing Postgresql after upgrading to OSX 10.7 Lion
  5. Change from SQLite to PostgreSQL in a fresh Rails project
  6. Getting a “bad interpreter” error when using brew
  7. Can’t install pg gem on Mountain Lion
  8. Cannot install pg gem in Mavericks with Postgres.app
  9. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  10. Difference between rake db:migrate db:reset and db:schema:load
  11. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  12. warning: Insecure world writable dir /usr/local/bin in PATH, mode 040777
  13. PG undefinedtable error relation users does not exist
  14. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  15. Ruby Bundle Symbol not found: _SSLv2_client_method (LoadError)
  16. Multiple databases in Rails
  17. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  18. docker postgres with initial data is not persisted over commits
  19. How do I use RVM and create globally available gems?
  20. Can I write PostgreSQL functions on Ruby on Rails?
  21. How do I set up the database.yml file in Rails?
  22. delete_all vs destroy_all?
  23. How to get Ruby / Homebrew / RVM to work on Yosemite?
  24. How to implement Active Record inheritance in Ruby on Rails?
  25. Store the day of the week and time?
  26. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  27. Rails: FATAL – Peer authentication failed for user (PG::Error)
  28. Changing a column type to longer strings in rails
  29. Adding foreign key to a rails model
  30. macOS, Rails: “Failed to build gem native extension”

Leave a Comment