Repairing Postgresql after upgrading to OSX 10.7 Lion

by

It’s a PATH issue. Mac OSX Lion includes Postgresql in the system now. If you do a which psql you’ll likely see usr/bin/psql instead of usr/local/bin/psql which is HomeBrew’s correct one. If you run brew doctor you should get a message stating that you need to add usr/local/bin to the head of your PATH env variable.

Editing your .bash_profile or .profile, or whichever shell you’re using and adding:
export PATH=/usr/local/bin:$PATH

as the first export for the PATH then either quit you shell session or source your file with source ~/.bash_profile and it should now be OK again.

More Related Contents:

  1. Ignoring time zones altogether in Rails and PostgreSQL
  2. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  3. Can’t find the PostgreSQL client library (libpq)
  4. Postgres could not connect to server
  5. Can not connect to local PostgreSQL
  6. Rails: Installing PG gem on OS X – failure to build native extension
  7. PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list
  8. Installing Postgres on windows for use with Ruby-on-Rails
  9. Rails auto-assigning id that already exists
  10. Can’t install pg gem on Mountain Lion
  11. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  12. Rails: FATAL – Peer authentication failed for user (PG::Error)
  13. Cannot install pg gem in Mavericks with Postgres.app
  14. Adding foreign key to a rails model
  15. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  16. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  17. ActiveRecord: size vs count
  18. How can I disable logging of asset pipeline (sprockets) messages in Ruby on Rails 3.1?
  19. Can someone explain collection_select to me in clear, simple terms?
  20. In Ruby on Rails, to extend the String class, where should the code be put in?
  21. Rails: How to run `rails generate scaffold` when the model already exists?
  22. Impossible to Install PG gem on my mac with Mavericks
  23. Rails 3: How to “redirect_to” in Ajax call?
  24. SimpleForm without for (non model form)
  25. nokogiri gem installation error
  26. Ruby: problem installing EventMachine under Windows 7
  27. Passing variables inside rails internationalization yml file
  28. How to make Devise redirect after confirmation
  29. rails 3 has_many :through Form with checkboxes
  30. Customizing Devise error messages in Rails 3?

Leave a Comment