Hello;

I have begun the "Getting Started with Rails" guide at
http://guides.rubyonrails.org/getting_started.html
which is supposed to create a simple blog.

I execute the command "rails blog -d postgresql" without incident.

I am having trouble with the next command in the tutorial:
"rake db:create".

The first time, I received the messages:

   FATAL:  role "blog" does not exist
   ...
   Couldn't create database for {"encoding"=>"unicode",
"username"=>"blog",
      "adapter"=>"postgresql", "database"=>"blog_development",
      "pool"=>5, "password"=>"xxxxyyy"}

So I created the postgres account blog and gave that account the
ability to create databases and users.  Now that same command
""rake db:create"" yields these messages:

   undefined method `quote_ident' for PGconn:Class
   ...
   Couldn't create database for {"encoding"=>"unicode",
"username"=>"blog",
      "adapter"=>"postgresql", "database"=>"blog_development",
      "pool"=>5, "password"=>"xxxxyyy"}

So what is the issue here?  Should I have created the three
user accounts before hand?

Could I just create the "blog" database before hand at the
postgres prompt?  If so, are there any tables that the
"rails blog -d postgresql" creates?

Thank you for your help.

P.S. my config/database.yml looks like this:

development:
  adapter: postgresql
  encoding: unicode
  database: blog_development
  pool: 5
  username: blog
  password: xxxxyyy

test:
  adapter: postgresql
  encoding: unicode
  database: blog_test
  pool: 5
  username: blog
  password: xxxxyyy

production:
  adapter: postgresql
  encoding: unicode
  database: blog_production
  pool: 5
  username: blog
  password: xxxxyyy

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to