Schema migration inside.
Plan (staging):
- [x] Backup tables to be dropped
- [x] idx.storage: Install new swh.indexer.storage version
- [x] idx.storage: Upgrade schema version
- [x] Upgrade worker versions
- [x] Restart indexer service
- [x] Checks [1]
Plan (production):
- [x] Backup tables to be dropped
- [x] idx.storage: Install new swh.indexer.storage version
- [x] idx.storage: Upgrade schema version
- [x] Upgrade worker versions
- [x] Restart indexer service
- [ ] Checks
[1]
```
10:04:11 swh-indexer@db1:5432=> select now(), count(*) from directory_intrinsic_metadata;
+-------------------------------+-------+
| now | count |
+-------------------------------+-------+
| 2022-06-10 08:04:52.166828+00 | 2 |
+-------------------------------+-------+
(1 row)
Time: 5.200 ms
```