Rails project can't connect to postgresql

Question

I was trying to create a rails project with postgresql

I use this

>>rails new ReadingList --database=postgresql
>>rails s

However, it shows this error

Then, I jump to psql and create readinglist_development by myself, but it still show the same error.

How did you create your database? have you tried doing rake db:create:all? — Derrick Mar
– Derrick Mar, Commented Jul 31, 2015 at 7:48
Your Rails is looking for ReadingList_development rather than readinglist_development. Check your database.yml in the config directory to change the database name. — Sebastian vom Meer
– Sebastian vom Meer, Commented Jul 31, 2015 at 7:48
yes, database: ReadingList_development is written in database.yml — rj487
– rj487, Commented Jul 31, 2015 at 10:46

nayiaw · Accepted Answer · 2015-07-31 07:48:32Z

3

In Rails practice, run rake db:create to create the database after creating new Rails project.

I believe the name of the database(readinglist_development) is not matching the database name of ReadingList_development as in database.yml which Rails does not recognize the database created using psql.

answered Jul 31, 2015 at 7:48

nayiaw

1,4565 gold badges17 silver badges28 bronze badges

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

1 Comment

rj487 Over a year ago

yeah, you have been a great help. I figure it out.

Sunil Kumar B G · Accepted Answer · 2015-07-31 08:14:43Z

0

Its better not to create databases form db workbenches, better to use rails db commands.

answered Jul 31, 2015 at 8:14

Sunil Kumar B G

262 bronze badges

1 Comment

rj487 Over a year ago

Thanks for you advice, I will use rails db command next time.

Collectives™ on Stack Overflow

Rails project can't connect to postgresql

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related