The PostgreSQL replication of the graph database between prado and somerset is currently hanging. We need to make a plan to fix it, and to implement that plan.
Current status of the new replica's recovery:
Data copy:
[ ] `content`
[ ] `directory`
[ ] `directory_entry_dir`
[ ] `directory_entry_file`
[x] `directory_entry_rev`
[x] `metadata_provider`
[x] `object_counts`
[x] `origin`
[x] `origin_metadata`
[x] `origin_visit`
[x] `person`
[x] `release`
[ ] `revision` (in progress)
[ ] `revision_history` (in progress)
[x] `skipped_content`
[x] `snapshot`
[x] `snapshot_branch`
[x] `snapshot_branches`
[x] `tool`
Indexes created on replica:
[ ] `content`
[ ] `directory`
[ ] `directory_entry_dir`
[ ] `directory_entry_file`
[x] `directory_entry_rev`
[x] `metadata_provider`
[x] `object_counts`
[ ] `origin` (in progress)
[x] `origin_metadata`
[ ] `origin_visit` (in progress)
[x] `person`
[x] `release`
[ ] `revision`
[ ] `revision_history`
[x] `skipped_content`
[x] `snapshot`
[x] `snapshot_branch`
[x] `snapshot_branches`
[x] `tool`