Can not connect to local PostgreSQL

by

This really looks like a file permissions error. Unix domain sockets are files and have user permissions just like any other. It looks as though the OSX user attempting to access the database does not have file permissions to access the socket file. To confirm this I’ve done some tests on Ubuntu and psql to try to generate the same error (included below).

You need to check the permissions on the socket file and its directories /var and /var/pgsql_socket. Your Rails app (OSX user) must have execute (x) permissions on these directories (preferably grant everyone permissions) and the socket should have full permissions (wrx). You can use ls -lAd <file> to check these, and if any of them are a symlink you need to check the file or dir the link points to.

You can change the permissions on the dir for youself, but the socket is configured by postgres in postgresql.conf. This can be found in the same directory as pg_hba.conf (You’ll have to figure out which one). Once you’ve set the permissions you will need to restart postgresql.

# postgresql.conf should contain...
unix_socket_directory = '/var/run/postgresql'       # dont worry if yours is different
#unix_socket_group = ''                             # default is fine here
#unix_socket_permissions = 0777                     # check this one and uncomment if necessary.

EDIT:

I’ve done a quick search on google which you may wish to look into to see if it is relavent.
This might well result in any attempt to find your config file failing.

http://www.postgresqlformac.com/server/howto_edit_postgresql_confi.html

Error messages:

User not found in pg_hba.conf

psql: FATAL:  no pg_hba.conf entry for host "[local]", user "couling", database "main", SSL off

User failed password auth:

psql: FATAL:  password authentication failed for user "couling"

Missing unix socket file:

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Unix socket exists, but server not listening to it.

psql: could not connect to server: Connection refused
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Bad file permissions on unix socket file:

psql: could not connect to server: Permission denied
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

More Related Contents:

  1. Postgres could not connect to server
  2. Rails: Installing PG gem on OS X – failure to build native extension
  3. Repairing Postgresql after upgrading to OSX 10.7 Lion
  4. Can’t install pg gem on Mountain Lion
  5. Cannot install pg gem in Mavericks with Postgres.app
  6. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  7. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  8. PostgreSQL gapless sequences
  9. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  10. PG::ConnectionBad – could not connect to server: Connection refused
  11. Rails 3 – can’t install pg gem
  12. warning: Insecure world writable dir /usr/local/bin in PATH, mode 040777
  13. Impossible to Install PG gem on my mac with Mavericks
  14. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  15. “gem install therubyracer -v ‘0.10.2’” on osx mavericks not installing
  16. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  17. docker postgres with initial data is not persisted over commits
  18. How do I use RVM and create globally available gems?
  19. Can I write PostgreSQL functions on Ruby on Rails?
  20. New data not persisting to Rails array column on Postgres
  21. Rails + Postgres drop error: database is being accessed by other users
  22. nokogiri gem installation error
  23. Getting a “bad interpreter” error when using brew
  24. PostgreSQL: FATAL – Peer authentication failed for user (PG::ConnectionBad)
  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