Can't recreate postgres db in rails app

Question

So, had a working postgres db instance with my rails app on my development Mac, but the migrations were getting unmanageable as I'm building the model up from scratch (i.e. adding, removing, changing columns), so I decided to start clean. After running rake db:drop, I can not recreate via rake db:create. I simply get the following:

Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "database"=>"xyz_development", "pool"=>5, "username"=>"xyz", "password"=>nil}

I am thinking I need to create the user in postgres, but shouldn't it be there from initial setup?

Thanks.

You should show us the real SQL error that was thrown in the background. — user330315
– user330315, Commented Apr 15, 2012 at 7:35

Michael Slade · Accepted Answer · 2012-04-05 04:44:14Z

1

You should see the SQL statement to create the database in the log output, and probably also the error. Check that.

Also check that the database doesn't already exist. Try creating the database manually using psql(1) with the username/password you use in rails and see what happens.

answered Apr 5, 2012 at 4:44

Michael Slade

13.9k2 gold badges41 silver badges44 bronze badges

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

Comments

fivetwentysix · Accepted Answer · 2012-04-15 07:27:51Z

0

$ createdb xyz_development

Use the postgres bin createdb

answered Apr 15, 2012 at 7:27

fivetwentysix

7,5159 gold badges42 silver badges59 bronze badges

Collectives™ on Stack Overflow

Can't recreate postgres db in rails app

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