Minor Planet Survey Replica

Overview

The Minor Planet Survey databases are replicated from the Minor Planet Center Annex. Logical Replication in Postgres is used to replicate the databases over the Internet.

The USDF replica is also setup as a publication and EPO in Google Cloud subscribes to receive the same data.

Application Grouping	Alert Production
Operating Hours
Criticality Level
GitHub Repository	slaclab/rubin-usdf-minor-planet-survey
Slack Support channel	ops-df-databases
Prod vCluster	usdf-minor-planet-survey
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
  • Rebuild Subscriptions
  • Rebuild Replicas
  • Schema Updates
  • Configure Publication for EPO
  • Obs Table Validation
  • Update IP Addresses for EPO Access
• Troubleshooting
  • Known Issues
  • Monitoring
  • Replication is broken
  • Replication Slot Already in Use
  • Schema Mismatch