#342 Migrating to PostgreSQL

#Rails users, have you considered #Postgres? @RailsCasts shows how to migrate to and what benefits you will experience

terminal 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 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@lo...

Full article: http://railscasts.com/episodes/342-migrating-to-postgresq...