Set current version of ruby
rvm --default use 2.1.1
Use migrate from named origin / dest in database.yml
-C Begin the output with a command to create the database itself and reconnect to the created database.
If –clean is also specified, the script drops and recreates the target database before reconnecting to it.
-h hostname
-U username
def getEnvironmentConfig(env = Rails.env) return Rails.configuration.database_configuration[env] end # Use migrate from named origin / dest in database.yml def migrateDbEnv(originStr, destStr) origin = getEnvironmentConfig(originStr) dest = getEnvironmentConfig(destStr) system "pg_dump -C -h #{origin["host"]} -U #{origin["username"]} #{origin["database"]} | psql #{dest["host"]} -U #{dest["username"]} #{dest["database"]}" end
http://blog.bigbinary.com/2012/10/18/backtick-system-exec-in-ruby.html