Ruby On Rails Error when running rake db:migrate

Question

When i run rake db:migrate i get this error:

rake aborted! could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

Any suggestions?

This is my database.yml file:

i think your postgres server is running in different port instead of 5432. please check this and let me know — vijikumar
– vijikumar, Commented Dec 5, 2012 at 10:15

rorra · Accepted Answer · 2012-12-05 09:57:08Z

1

The problem is that your rails application is trying to connect to the database, by using the configuration that you have on config/database.yml

It seems that you have configured a connection to a PostgreSQL but that the rails application cannot connect so it throws that error.

Check that you have the right credentials on config/database.yml and make sure postgresql is running.

edited Dec 5, 2012 at 9:57

answered Dec 5, 2012 at 9:00

rorra

9,6883 gold badges43 silver badges64 bronze badges

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

Comments

sjain · Accepted Answer · 2012-12-05 09:15:18Z

0

Whenever you get the error like this check if something went wrong as:

Probably the host is not added.

Adding host to database.yml file -

development:
  adapter: postgresql
  encoding: utf8
  database: myapp_development
  username: myuser
  host: localhost

test:
  adapter: postgresql
  encoding: utf8
  database: myapp_test
  username: myuser
  host: localhost

production:
  adapter: postgresql
  encoding: utf8
  database: myapp_production

answered Dec 5, 2012 at 9:15

sjain

23.4k30 gold badges115 silver badges190 bronze badges

Collectives™ on Stack Overflow

Ruby On Rails Error when running rake db:migrate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related