I Cannot Migrate my Database from SQLite to PostgreSQL
Since my last post, I've been attempting to extrapolate features taught in the Rails Tutorial into the blog app I built through RailsGuides.
This time around, I've decided to go back and complete all the exercises put forth on the Rails Tutorial. I've had more than my fair share of trouble completing Chapter 3 Exercise 3 which has me migrate my SQLite database to PostgreSQL.
I installed PostgreSQL successfully (I think) from the link provided in the tutorial. I've updated my Gemfile appropriately (I think). I've updated my database.yml file ten ways from Tuesday, however, and am still pretty sure it's wrong.
My database.yml file for your reference:
development:
 adapter: postgresql
 encoding: utf8
 database: blog_development
 pool: 5
 username: brianscottk
 password: <my password>
test:
 adapter: postgresql
 encoding: utf8
 database: blog_test
 pool: 5
 username: brianscottk
 password: <my password>
production:
 encoding: utf8
 database: blog_production
 adapter: postgresql
 pool: 5
 username: brianscottk
 password: <my password>
Every time I try and run rake db:create:all, however, I keep getting the same dang error message that says "Couldn't create database for...<all of the above parameters>.
I've Googled a ton for an answer, but most of the posts like this one don't provide any solutions that work for me. I guess being on Windows instead of Mac is making this more difficult than it could be.
Anyone out there have any suggestions?











