I launched my Cloud9 Rails project to Heroku (yay!). In doing so, I changed the Gemfile from "gem 'sqlite3'" to "gem 'pg'" and added "gem 'rails_12factor', group: :production" and bundle installed it. I did this because Heroku prefers PostgreSQL.
My project is running fine on Heroku and is using PostgreSQL in production. However my development environment on Cloud9 is still SQLite3 (my database.yml is still the same) -- is this an issue? I heard that we should always use the same database platfrom for dev and prod.
So I'm now migrating my Cloud9 dev environment to PostgreSQL. I saw this guide: https://community.c9.io/t/setting-up-postgresql/1573 But it seems like it's for a brand new project... what do I do if I have a pre-existing project?
I saw this guide - http://railscasts.com/episodes/342-migrating-to-postgresql?view=asciicast (scroll down to "Migrating an Existing Application") and the directions look quite different.
Which one do I follow? Is there a good Cloud9 tutorial for migrating existing projects to postgres?