Rails rejects my database.yml with "'postgresql' database is not configured"

Question

I have tried everything I have read on the internet but cannot seem to get it to work. I am trying to set it up on a new project. Here is my database.yml file:

development:
adapter: postgresql
encoding: unicode
database: timetracker_development
pool: 5
username: postgres
password:
host: localhost

test:
adapter: postgresql
encoding: unicode
database: timetracker_test
pool: 5
username: postgres
password:
host: localhost

production:
adapter: postgresql
encoding: unicode
database: timetracker_production
pool: 5
username: timetracker
password:

And the error i get on my web page:

'postgresql' database is not configured. Available: ["development", "adapter", "encoding", "database", "pool", "username", "password", "host", "test", "production"]

I installed postgress via brew and then did the init command and when I type the start command all it says is "server starting". Does this mean it did or didn't start? Anyone know how I can get this to work?

What is this database.yml, and what is it for? I have used postgresql for 15 years, and never had any such database.yml on my computer. — Antti Haapala
– Antti Haapala, Commented May 29, 2014 at 11:18
@AnttiHaapala This is the file in my rails project, probably should have mentioned that. — HarryLucas
– HarryLucas, Commented May 29, 2014 at 11:25

Craig Ringer · Accepted Answer · 2014-05-29 11:47:39Z

1

Indenting is significant in YAML.

blah:
blah2: 1

means a different thing to:

blah:
    blah2: 1

answered May 29, 2014 at 11:47

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

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

Comments

socjopata · Accepted Answer · 2014-05-29 11:49:38Z

1

Here is how your database.yml should look like:

development:
  adapter: postgresql
  encoding: unicode
  database: timetracker_development
  pool: 5
  username: postgres
  password:
  host: localhost

test:
  adapter: postgresql
  encoding: unicode
  database: timetracker_test
  pool: 5
  username: postgres
  password:
  host: localhost

production:
  adapter: postgresql
  encoding: unicode
  database: timetracker_production
  pool: 5
  username: timetracker
  password:

answered May 29, 2014 at 11:49

socjopata

5,1053 gold badges32 silver badges33 bronze badges

Collectives™ on Stack Overflow

Rails rejects my database.yml with "'postgresql' database is not configured"

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