ruby on rails 3 - heroku pgbackups - how does it work? -
i'm trying migrate database on new app existing 1 using pgbackups, i'm running issues. i've read documentation on heroku's dev site i'm still getting errors.
i've got plugin installed both databases , can go source db , copy/capture it.
$ heroku pgbackups:capture -a costrecovery --expire heroku_postgresql_onyx_url (database_url) ----backup---> b007 ←[0kcapturing... doneb - ←[0kstoring... done
and change directory of app want copy db , followed instructions listed heroku. problem don't know if it's not working because bug or if it's because i'm not interpreting instructions properly, entirely possible. first i'll list instructions heroku's dev site , commands i've tried.
herokus instructions
$ heroku pgbackups:restore database -a target-app \ `heroku pgbackups:url -a source-app`
commands i've tried
$ heroku pgbackups:restore database_url -a boiling-reef-2060 \ > heroku pgbackups:url -a costrecovery ! backup not found $ heroku pgbackups:restore heroku_postgresql_green_url -a boiling-reef-2060 \ > 'heroku pgbackups:url -a costrecovery' ! backup not found $ heroku pgbackups:restore database -a boiling-reef-2060 \ > 'heroku pgbackups:url -a costrecovery' ! backup not found $ heroku pgbackups:restore database_url -a costrecovery-copy2 \ > heroku pgbackups:"https://s3.amazonaws.com/hkpgbackups/app405411@heroku.com/b 007.dump?awsaccesske > yid=akiajfdirycgynfxr4fq&expires=1365184330&signature=po0wz982jbx%2fkv0bkk0iv p%2 > frwac%3d" ! resource not found
can helpl me out proper syntax? thanks
pgbackups can restore database on same app, or pgbackups url, in, 1 captured in source application/database. instructions use backticks (`) shell out , grab pgbackups url source application. pgbackups:url command provide such url. try running this, understand what's happening:
heroku pgbackups:url -a costrecovery
(assuming costrecovery captured data).
knowing this, should able run:
heroku pgbackups:restore database_url --app boiling-reef-2060 `heroku pgbackups:url --app costrecovery
Comments
Post a Comment