On Mon, 16 Jan 2017 14:55:05 +0100 Aurelien Bompard <[email protected]> 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
pgpUvEy3cH07y.pgp
Description: OpenPGP digital signature
_______________________________________________ infrastructure mailing list -- [email protected] To unsubscribe send an email to [email protected]
