Send me latest database dump

[santheo]

My local environment is so lacking in data that it's making it hard to test. Thanks.

[cgansen]

cap production db:snapshot
(…stuff…)
cap production db:restore

[santheo]

I didn't have capistrano installed, so I installed it. Now I get an error:

/Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/1.9.1/rubygems/custom_require.rb:36:in `require': cannot load such file -- railsless-deploy (LoadError)
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/1.9.1/rubygems/custom_require.rb:36:in `require'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:152:in `require'
    from Capfile:2:in `load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:93:in `instance_eval'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:93:in `load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:180:in `load_from_file'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:89:in `load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:86:in `block in load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:86:in `each'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/configuration/loading.rb:86:in `load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/cli/execute.rb:65:in `block in load_recipes'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/cli/execute.rb:65:in `each'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/cli/execute.rb:65:in `load_recipes'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/cli/execute.rb:31:in `execute!'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/lib/capistrano/cli/execute.rb:14:in `execute'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/lib/ruby/gems/1.9.1/gems/capistrano-2.15.5/bin/cap:4:in `<top (required)>'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/bin/cap:23:in `load'
    from /Users/sandor/.rbenv/versions/1.9.3-p448/bin/cap:23:in `<main>'

This rbenv stuff is there because of Starter League projects and I dunno, maybe it's getting in the way.

[cgansen]

in your cwfy root, run bundle install then try again.

[cgansen]

Alternatively, I just did another snapshot; you are free to use it:

curl -o /tmp/cwfy-restore-staging.dump http://cwfy-database-backups.s3.amazonaws.com/staging.dump
dropdb cwfy
createdb cwfy
pg_restore -d cwfy -O -c /tmp/cwfy-restore-staging.dump
rm -f /tmp/cwfy-restore-staging.dump

[santheo]

Bundle install fixed it. Then when I run cap production db:snapshot it asks for a password. What password would that be?

[santheo]

(The download worked, though. Thx)