PostgreSQL replication issues between prado and somerset

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
• directory_entry_rev
• metadata_provider
• object_counts
• origin
• origin_metadata
• origin_visit
• person
• release
• revision
• revision_history
• skipped_content
• snapshot
• snapshot_branch
• snapshot_branches
• tool

Indexes created on replica:

• content
• directory
• directory_entry_dir
• directory_entry_file
• directory_entry_rev
• metadata_provider
• object_counts
• origin
• origin_metadata
• origin_visit
• person
• release
• revision
• revision_history
• skipped_content
• snapshot
• snapshot_branch
• snapshot_branches
• tool

---

Migrated from T1534 (view on Phabricator)