Restore a db on meronense from backup
I have an issue on metrics tpo where it would save me weeks of re-parsing descriptors if I could restore two tables on the userstats db from backups.
I would need ideally to have a userstats_copy db from before the 1st of October 2020 so I can copy over data for the month of september.
-
setup new temp VM (@anarcat, done, metrics-backup-01) -
restore meronense backup (@anarcat, done) -
start the database, replay WAL files up to october 1st ( service postgresql start
, @anarcat ) -
restore the table to meronense (@hiro) -
remove the SSH key from bungei ( rm /etc/ssh/userkeys/torbackup.more
, @anarcat) -
remove firewall rule ( iptables-legacy -D INPUT -s 49.12.57.139 -j ACCEPT
, @anarcat t) -
wait for hiro to give the go to retire the server (@anarcat) -
retire the backup host (@anarcat), which is: -
remove backups -
gnt-instance remove
-
remove from LDAP -
remove from tor-passwords -
remove from puppet
-
Edited by anarcat