On Mon, 16 Jan 2017 14:55:05 +0100 Aurelien Bompard <abompard@xxxxxxxxxxxxxxxxx> wrote: > Hey folks, > > I have a big mailman update that I'd like to test on staging, and I > think that my testing would be more realisting if I had some > production data on the staging DB. I mostly need public data, I don't > need the user accounts or the private lists data for example. > I realize that I could dump the prod DB to a text file (excluding > private tables), transfer it to my workstation and re-upload it to > staging, but I'm talking gigabytes of data here, so I wonder if you > know of a better way, that would stay in the Fedora Infra (and > possibly in the same datacenter). Make a staging sync playbook. ;) Look at the ansible/playbooks/manual/staging-sync/koji.yml it takes the prod db, syncs it over to staging and then runs some sql on it to get it working for staging. ;) So, basically you just need to do this for your db... kevin
Attachment:
pgpjAWDH3SqZu.pgp
Description: OpenPGP digital signature
_______________________________________________ infrastructure mailing list -- infrastructure@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to infrastructure-leave@xxxxxxxxxxxxxxxxxxxxxxx
