What to use when 'development' means development in Heroku pipeline
danielmcquillen opened this issue · 2 comments
Sorry if this is obvious and I'm just missing it!
'development' seems reserved for the local database. How would you configure parity if one wants development restore-from production
to copy the heroku production database to the heroku development server in a pipeline and something like local restore-from production
to copy it to the local db.
I imagine defining 'local' and 'development' in the database.yml is a step in that direction, but then confused as to how I'd invoke parity on the command line if the first term is an (arbitrary) name like 'local' defined in the database.yml.
Many thanks for the helpful tool!
Hi!
Heroku strongly advises against putting production data in review application databases (I think you're talking about review apps when you're talking about development servers?).
Copying full database contents to a Review apps is not currently supported. Copying production data to test apps means risk of data leaks or other programming mistakes operating on recent customer data. Instead, we recommend seeding databases comprehensively with non-production data using seed scripts run with the postdeploy command.
I think if your PR apps were named using the deterministic naming structure (note: not the default in the new pipelines, but configurable) that you could leverage the pr_app
command to restore a production backup. Something like this:
pr_app myapp-staging-pr-1234 restore-from production
If there's a gap here and there's a PR to make the Backup
or Environment
class facilitate a staging restore to a PR app database I'd be very happy to review a PR.
@geoffharcourt Thanks for the quick response. Aha. I guess you're right, I'm trying to bend parity to do something I probs shouldn't. I'll close the issue. Thanks again.