I recently updated my machine (MacBook Pro running Mountain Lion) and ever since then, whenever I set up a rails project, my machine craps out and cannot connect to PG. Currently, this is the error I am getting when I try to go to localhost;
PG::ERROR could not connect to server: Connection refused Is the server running on host "localhost"
(::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection
refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (fe80::1) and accepting TCP/IP connections on port 5432?
Here is a checklist, and list of things I have tried;
host: localhost
in my database.yml filebrew uninstall postgresql
then brew install postgresql
Ran locate pg_hba.conf
and terminal shot this out;
WARNING: The locate database (/var/db/locate.database) does not exist.
I have also tried using rails 4.0 but I still get the problem
I can still work on other projects on my machine that were started/finished before I updated my computer.
When I run psql
from my terminal I get
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I am really lost here, and am not sure what else to do. Any help would be much appreciated.
UPDATE:
Thanks to this question, all was resolved by simply downloading Postgres.app for Mac. Everything works great now.
if you have installed through brew
$ brew services stop postgresql
#adjust below path accordingly to your machine
$ rm /usr/local/var/postgres/postmaster.pid
$ brew services start postgresql
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With