Summit Database Replica

Overview

The consolidated database, exposurelog, narrativelog, and nightreport Postgres databases are replicated from the Summit to the USDF. The hostname for the summit instance is db-lhn.cp.lsst.org. Logical Replication in Postgres is used to replicate the databases across the LHN. Physical Replication was previously set up, but was found to be too unstable in the event of network issues and with rebuilds weekly and sometimes multiple times a week. Physical Replication also requires the entire contents of the database instance be replicated which was not ideal because extra databases were replicated that are not needed at the USDF. Logical Replication allows for selective replication of schemas and tables.

Application Grouping	QA
Operating Hours	24x7
Criticality Level
GitHub Repository	slaclab/rubin-usdf-summit-db-replica-deploy
Slack Support channel	ops-df-databases
Prod vCluster	usdf-summitb
Dev vCluster	None

• Database Information
  • Architecture
  • Architecture Diagram
  • Associated Systems
  • Configuration Location
  • Data Flow
  • Dependencies - S3DF
  • Dependencies - External
  • Disaster Recovery
• Documentation and Training
• Security
  • Requesting Access
  • Service accounts
  • Security Incident Response
  • Security Policies
• Procedures
  • Deployment
  • Maintenance
  • Backup
  • Cold Startup
  • Cold Shutdown
  • Reproduce Service
  • Downloading Summit Postgres schemas
  • Rebuild Subscriptions
  • Schema Updates - ConsDB
  • Schema Updates - Exposurelog, Narrativelog, Nightreport
  • Add Tables to Publication
  • Drop Replication Slot on the Publication
• Troubleshooting
  • Known Issues
  • Monitoring
  • Replication Slot Issues
  • Schema Mismatch