capistrano-db-tasks
capistrano-db-tasks copied to clipboard
sgruhier
Add capistrano tasks for syncing remote and local database
for postgres database, i changed dump with clean flag then import. normally, we use cap staging db:pull or db:push to sync databases between local and staging for testing, i think...
I understand that eventually these will dissapear with capistrano cleanup, but is there a reason these dump files arent cleared by the gem itself, I dont see an option in...
Hi, My `deploy_to` is at `~` on my machine and this isnt supported. I get the error talked about at http://stackoverflow.com/a/9669507/1520364 . I am not sure if this is a...
first, the log ``` INFO [5b7228a5] Running /usr/bin/env cd /home/deployer/apps/artoflife/current && bunzip2 -f db/artoflife_development_2014-04-24-200512.sql.bz2 && RAILS_ENV=production && PGPASSWORD='deployer123./' psql -c "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'artoflife_production' AND pid...
https://github.com/sgruhier/capistrano-db-tasks/blob/master/lib/capistrano-db-tasks/database.rb#L64 notice it's using `@cap.local_rails_env.to_s`. I believe it should be using `@cap.rails_env.to_s` since thats the rails_env that's on the server. Changing it to this on my fork seemed to fix...
using the latest version from git: 5ecffdba5d3da0a23556056d52c56c7f6b0f4f5b ``` [jc@mac] cap db:pull triggering load callbacks * 2013-09-25 06:16:12 executing `production' triggering start callbacks for `db:pull' * 2013-09-25 06:16:12 executing `multistage:ensure' *...
It looks like you started this and commented it out. It would be ideal if this created it via mysqladmin and not with rails/rake tasks, as I'm also using the...
I'm running into an error that can be solved by adding `--complete-insert` to the `mysqldump` command, caused by having a structure where a non-unique identifier follows the actual identifier: ```...
- [x] allow supporting rvm if any with uncompatible ruby versions - [x] added createrole and createdb for postgres and mysql dbs
The method that's supposed to translate this Capistrano setting into a CLI argument just returns nil for non-Postgres database 🤷🏻♂️ https://github.com/sgruhier/capistrano-db-tasks/blob/d9690dea0faeccba09aa937bbde858c9776bc277/lib/capistrano-db-tasks/database.rb#L99-L102 I suppose it's because `mysqldump` doesn't support this option...
