Procedures

Intended audience: Anyone who is administering the MPC Sandbox.

Deployment

Deployments are done with a Makefile make run-apply will apply the configuration.

Maintenance

Backup

The MPC Sandbox is not backed up because data is replicated from the Minor Planet Center. The restore process is detailed in Build MPC Sandbox

Cold Startup

No specific cold startup procedures needed.

Cold Shutdown

No specific cold shutdown procedures needed.

Reproduce Service

Refresh the Subscriptions

To refresh subscriptions after tables updates run.

ALTER SUBSCRIPTION usdf_mpc_obs_ingest_sub REFRESH PUBLICATION;
ALTER SUBSCRIPTION usdf_mpc_obs_sbn_sub REFRESH PUBLICATION;
ALTER SUBSCRIPTION usdf_mpc_orbits_sub REFRESH PUBLICATION;

Drop all Subscriptions

To drop all subscriptions run the below commands.

DROP SUBSCRIPTION usdf_mpc_obs_ingest_sub;
DROP SUBSCRIPTION usdf_mpc_obs_sbn_sub;
DROP SUBSCRIPTION usdf_mpc_orbits_sub;