[tor-bugs] #32998 [Internal Services/Tor Sysadmin Team]: Upgrade metrics hosts to buster

[Tor Bug Tracker & Wiki]

#32998: Upgrade metrics hosts to buster
-------------------------------------------------+-------------------------
 Reporter:  karsten                              |          Owner:  anarcat
     Type:  task                                 |         Status:
                                                 |  needs_information
 Priority:  Medium                               |      Milestone:
Component:  Internal Services/Tor Sysadmin Team  |        Version:
 Severity:  Normal                               |     Resolution:
 Keywords:                                       |  Actual Points:
Parent ID:                                       |         Points:
 Reviewer:                                       |        Sponsor:
-------------------------------------------------+-------------------------

Comment (by anarcat):

 alright, so we had a bit of trouble with the upgrade because of a change
 in the `pg_proc` internal table. that table format changed, which broke a
 view used by the metrics team for internal test.

 after a bit of wrangling, karsten was able to figure out those views were
 not in use in production and dropped them from the 9.6 cluster. then the
 upgrade went along smoothly.

 i've made the cluster v11 online. the 9.6 cluster is still around in case
 we need it, and we have full backups of that cluster before the upgrade.
 i've also launched a new full/base backup of the new cluster right now,
 which should take about an hour to complete.

 i documented the upgrade procedure here as well:

 https://help.torproject.org/tsa/howto/upgrades/buster/#PostgreSQL

 we'll wait ~12h for the new batch or results to come into the database and
 then, if the metrics team is happy with the results, we can remove the old
 cluster and (maybe after a delay?) the 9.6 backups.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/32998#comment:10>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online