So I'm still having issue's attempting to get my postgresql db running on my rails apps since the Yosemite upgrade. I wish I never upgraded now. I've searched the net and there is a related question here on stackoverflow about this same issue.
`pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)
I am getting the same error on my command line.
No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
and in my web browser it gives me the PG::ConnectionBad error.
I did the solution that @Donovan stated for solving the issue by adding the three missing directories pg_tblspc,pg_twophase,pg_stat_tmp
that for some reason Yosemite got rid of. I ran all the correct command line operations but still receive the same error and no luck. This is what my database.yml file looks like as well.
# PostgreSQL. Versions 8.2 and up are supported.
#
# Install the pg driver:
# gem install pg
# On Mac OS X with macports:
# gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
# On Windows:
# gem install pg
# Choose the win32 build.
# Install PostgreSQL and put its /bin directory on your path.
#
# Configure Using Gemfile
# gem 'pg'
#
development:
adapter: postgresql
encoding: unicode
database: task_manager_development
pool: 5
# Connect on a TCP socket. Omitted by default since the client uses a
# domain socket that doesn't need configuration. Windows does not have
# domain sockets, so uncomment these lines.
# host: localhost
# port: 5432
# Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error, fatal, and panic
# The server defaults to notice.
#min_messages: warning
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
adapter: postgresql
encoding: unicode
database: task_manager_test
pool: 5
production:
adapter: postgresql
encoding: unicode
database: task_manager_production
pool: 5
I've also tried un-commenting out the localhost and port 5432 and still have no luck. I really need help here. Basically everything else I've read online too says that adding those multiple directories and restarting your postgresql should solve the problem but it hasn't worked for me. I must not be doing something correctly or am missing something. I'm considering re-installing homebrew and ROR but i'm afraid I may lose all my data from my ROR apps. Any help would be great!!