Currently, backups are done manually. Labs should have a real backup solution, but for now, we need a real backup solution.
Okay I made wikilabels-dumps.wmflabs.org/psql_dumps/ and documented the steps in https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikilabels/Backups. I'd love to see a puppetized node but that might be too much work for too little gain.
What do you think?
wikilabels-backup is a VM, currently (but not permanently) hosted on labvirt1015. pgsql.eqiad.wmnet is, as Ladsgroup says, a cname for labsdb1004. So they are definitely on different hardware but are in the same datacenter.