Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 8801f1f125

Fetching latest commit…

Cannot retrieve the latest commit at this time

..
Failed to load latest commit information.
blog-after
store-after
store-before
README.md

README.md

RailsCasts Episode #342: Migrating to PostgreSQL

http://railscasts.com/episodes/342-migrating-to-postgresql

Requires Ruby 1.9.2 or higher.

Commands used in this episode

psql --version
brew install postgresql
initdb /usr/local/var/postgres
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
which psql
rails new blog -d postgresql
rake db:create:all
rails g scaffold article name content:text
rake db:migrate
psql blog_development
rails db
gem install taps
taps
taps server sqlite://db/development.sqlite3 rbates secret
taps pull postgres://rbates@localhost/store_development http://rbates:secret@localhost:5000

Commands used in database console

select * from articles;
\d
\d articles
\?
\h
\h select
\q
Something went wrong with that request. Please try again.