hello postgres database connection errors Ruby on rails

Question

i'm new to ruby on rails, i'm trying to run an app with postgres database, but it didn't work, i have tried to search lots of information, but i wasn't useful, Someone posted the exactly same question here Problems with rails server , I tried to use command rails new blog it created an app with sqlite3 database, it works fine, but i created app with command rails new myapp --database=postgresql after that i visit localhost page, it ocurred the exactly same error

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"?

Can anyone help? it would be very much appreciated.

database.yml file information:

default: &default
  adapter: postgresql
  encoding: unicode
  pool: 5

development:
  <<: *default
  database: myapp_development

test:
  <<: *default
  database: myapp_test

production:
  <<: *default
  database: myapp_production
  username: myapp
  password: <%= ENV['MYAPP_DATABASE_PASSWORD'] %>

Can you include your config/database.yml file in your question please? — Luca B.
– Luca B., Commented Aug 21, 2014 at 7:51
Hello, i have just included the yml file, Thank you very much — gqli
– gqli, Commented Aug 21, 2014 at 7:58
Did you check your db is actually running on it's default port? Also what environment you're currently running the app in? — Luca B.
– Luca B., Commented Aug 21, 2014 at 8:00
Hello, i'm a beginner,I couldn't find pg_hba.conf. I am running it on my local MAC OS 10.9.4 ,Thank you guys. — gqli
– gqli, Commented Aug 21, 2014 at 8:08

Community · Accepted Answer · 2017-05-23 11:57:42Z

0

Delete this file:

/usr/local/var/postgres/postmaster.pid

Original Answer: psql: could not connect to server: No such file or directory (Mac OS X)

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Aug 21, 2014 at 9:27

Amr Arafat

4893 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gqli Over a year ago

Thanks for Answering this question, i think your comment inspired my to solve the issue, It's related. Here is the link i followed up with, i reinstalled home-brew and Postges moncefbelyamani.com/…

Collectives™ on Stack Overflow

hello postgres database connection errors Ruby on rails

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related