Page MenuHomeSoftware Heritage
Create Task
Maniphest T880

Add softwareheritage-indexer backup
Closed, MigratedEdits Locked
Actions

Description

As a general rule of thumbs, it's good to have backup :)
And we did up until we separated the db (T867).

Tables to backup:

  • origin_intrinsic_metadata
  • revision_intrinsic_metadata tables

The other ones may be of lesser importance:

  • content_mimetype
  • content_fossology_license

Related Objects
Search...

Event Timeline

ardumont created this task.Dec 11 2017, 3:45 PM
olasd added a parent task: T881: PostgreSQL backups based on pg_dump.Dec 11 2017, 3:52 PM
olasd edited projects, added System administration; removed Indexer.
ardumont mentioned this in T944: Separate indexer db to its own postgresql cluster.Feb 1 2018, 12:14 PM
ardumont added a subtask: T944: Separate indexer db to its own postgresql cluster.
ardumont changed the status of subtask T944: Separate indexer db to its own postgresql cluster from Open to Work in Progress.Feb 7 2018, 12:17 PM
ardumont closed subtask T944: Separate indexer db to its own postgresql cluster as Resolved.Feb 7 2018, 7:28 PM
zack added a subscriber: zack.May 25 2019, 5:17 PM

Just checking in on this, are we are discussing moving DBs around. Do we still don't have a backup for the indexer DB?
If so, priority of this one should probably be raised.

zack removed a parent task: T881: PostgreSQL backups based on pg_dump.May 25 2019, 5:21 PM
zack added a subtask: T881: PostgreSQL backups based on pg_dump.
ardumont raised the priority of this task from Low to Normal.May 27 2019, 11:13 PM

Indeed, we don't have it yet.
We only have a replica on azure (dbreplica1.euwest.azure).

Note: we are moving dbs out of louvre but not swh-indexer (it's on somerset).

ardumont removed a subtask: T881: PostgreSQL backups based on pg_dump.Jun 20 2019, 6:07 PM
ardumont added a parent task: T881: PostgreSQL backups based on pg_dump.
ardumont updated the task description. (Show Details)Feb 2 2022, 2:33 PM
gitlab-migration closed this task as Migrated.Oct 19 2022, 5:53 PM
gitlab-migration claimed this task.
gitlab-migration added a subscriber: gitlab-migration.

This task has been migrated to GitLab.

gitlab-migration changed the status of subtask T944: Separate indexer db to its own postgresql cluster from Resolved to Migrated.Oct 19 2022, 5:53 PM
About · Developer information · Legal