Movatterモバイル変換

[0]ホーム
URL:

Minor Planet Center Annex

@ SBN

 

Database Status:GREEN

23 Jan 2026

  1. Nominal.

Pleasereport concerns!

KEY

Database Replication

Instructions (not for the faint of heart) forreplicating the database are posted. Questions/issues related to replication should be directed toAndrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2026-02-17 13:20:01 (GMT)

Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.

MariaDB mpc_development:

Source file of data:statusDB.csv

TableCountCreated_atUpdated_at
comet_names52142025-10-23 17:12:592025-10-23 17:12:59
comet_orbits112192026-02-13 22:16:372026-02-13 23:01:04
identifications2116412026-01-14 12:15:202026-01-14 12:15:20
isolated_tracklets497710452026-02-17 13:08:142026-02-17 13:08:14
mp_discoverers19691472025-06-18 21:18:062025-06-18 21:18:06
numbered_comet_identifications12922025-10-23 16:03:492025-10-23 16:03:49
numbered_identifications13191252025-10-22 17:46:282025-10-22 17:46:28
numbered_mps8751502011-10-28 09:36:112026-01-12 14:34:38
obs_request_observers522019-07-24 16:57:482019-07-24 16:57:48
obs_request_users72015-12-04 00:25:222015-12-04 00:25:22
observations5024992982026-02-17 12:30:032026-02-17 12:30:03
orbit_uncertainties7871932019-06-03 12:14:452022-06-02 16:46:34
orbits15343042025-09-03 13:02:102026-02-17 13:02:13
radar_observations15072024-12-04 04:59:182024-12-04 04:59:18
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

TableCountCreated_atUpdated_at
neocp_els572026-02-13 12:15:42.2666982026-02-17 13:23:33.064897
neocp_events3114212026-02-17 13:23:33.2721072026-02-17 13:23:33.272107
neocp_obs_archive7797332026-02-17 13:23:33.0236942026-02-17 13:23:33.023694
neocp_obs10102026-02-17 13:23:32.9830012026-02-17 13:23:32.983001
neocp_prev_des710332026-02-17 11:07:06.3357242026-02-17 11:07:06.335724
neocp_var1012612026-02-17 13:23:33.1512562026-02-17 13:23:33.151256
current_identifications20444922026-02-17 13:07:46.336362026-02-17 13:08:28.721672
numbered_identifications8759812026-02-11 03:01:35.428832026-02-11 03:01:35.42883
primary_objects15602222026-02-17 13:07:46.3053052026-02-17 13:07:46.305305
obs_sbn5285321152026-02-17 07:22:14.049216-052026-02-17 08:16:38.18902-05
obs_alterations_deletions14737012026-02-17 10:59:03.2049672026-02-17 10:59:03.204967
obs_alterations_redesignations45152026-01-03 19:19:15.9113422026-01-03 19:19:15.911342
obs_alterations_unassociations5541812026-02-17 07:32:38.7856952026-02-17 07:32:38.785695
mpc_orbits15165702021-02-04 00:57:51.9012062026-02-17 13:16:38.18902
minor_planet_names259922011-10-27 06:38:132026-01-16 00:37:34.652007
obscodes26782026-02-10 17:33:01.1559412026-02-10 17:33:01.155941
comet_names42952023-08-15 14:55:17.3056792026-02-05 00:12:51.9462
No change to Postgres mpc_sbn database structure

YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old

Replication status view MPC-master → [SBN] → MPC-replica:

ServerTableCountUpdated_atQueried_at
MPC_primarydbobs_sbn5285255162026-02-17 12:58:15.6244262026-02-17 13:00:02.029899
MPC_mpcsbndbobs_sbn5285255162026-02-17 12:58:15.6244262026-02-17 13:00:20.403821
SBN_to_AWSobs_sbn5285255162026-02-17 12:58:15.6244262026-02-17 13:00:43.933579
MPC_primarydbcurrent_identifications20444912026-02-17 11:07:32.7779122026-02-17 13:06:23.756225
MPC_mpcsbndbcurrent_identifications20444912026-02-17 11:07:32.7779122026-02-17 13:06:24.246811
SBN_to_AWScurrent_identifications20444912026-02-17 11:07:32.7779122026-02-17 13:06:24.483039
MPC_primarydbcomet_names42802026-02-05 00:12:51.94622026-02-17 13:06:24.738958
MPC_mpcsbndbcomet_names42802026-02-05 00:12:51.94622026-02-17 13:06:24.849281
SBN_to_AWScomet_names42802026-02-05 00:12:51.94622026-02-17 13:06:24.938789
MPC_primarydbminor_planet_names259922026-01-16 00:37:34.6520072026-02-17 13:06:25.032058
MPC_mpcsbndbminor_planet_names259922026-01-16 00:37:34.6520072026-02-17 13:06:25.184583
SBN_to_AWSminor_planet_names259922026-01-16 00:37:34.6520072026-02-17 13:06:25.286602
MPC_primarydbmpc_orbits15165692026-02-17 12:29:10.81792026-02-17 13:06:25.382173
MPC_mpcsbndbmpc_orbits15165692026-02-17 12:29:10.81792026-02-17 13:06:27.415644
SBN_to_AWSmpc_orbits15165692026-02-17 12:29:10.81792026-02-17 13:06:27.605365
MPC_primarydbnumbered_identifications8759812026-02-11 03:01:35.428832026-02-17 13:06:27.836755
MPC_mpcsbndbnumbered_identifications8759812026-02-11 03:01:35.428832026-02-17 13:06:28.189411
SBN_to_AWSnumbered_identifications8759812026-02-11 03:01:35.428832026-02-17 13:06:28.328558
MPC_primarydbneocp_els572026-02-17 13:05:37.5912622026-02-17 13:06:28.470598
MPC_mpcsbndbneocp_els572026-02-17 13:05:37.5912622026-02-17 13:06:28.577905
SBN_to_AWSneocp_els572026-02-17 13:05:37.5912622026-02-17 13:06:28.665239
MPC_primarydbneocp_events3114192026-02-17 13:05:37.805082026-02-17 13:06:28.756185
MPC_mpcsbndbneocp_events3114192026-02-17 13:05:37.805082026-02-17 13:06:28.946139
SBN_to_AWSneocp_events3114192026-02-17 13:05:37.805082026-02-17 13:06:29.06915
MPC_primarydbneocp_obs10032026-02-17 13:05:37.5415832026-02-17 13:06:29.181671
MPC_mpcsbndbneocp_obs10032026-02-17 13:05:37.5415832026-02-17 13:06:29.291357
SBN_to_AWSneocp_obs10032026-02-17 13:05:37.5415832026-02-17 13:06:29.379414
MPC_primarydbneocp_obs_archive7797262026-02-17 13:05:37.5498322026-02-17 13:06:29.476624
MPC_mpcsbndbneocp_obs_archive7797262026-02-17 13:05:37.5498322026-02-17 13:06:29.743535
SBN_to_AWSneocp_obs_archive7797262026-02-17 13:05:37.5498322026-02-17 13:06:29.883911
MPC_primarydbneocp_prev_des710332026-02-17 11:07:06.3357242026-02-17 13:06:30.022771
MPC_mpcsbndbneocp_prev_des710332026-02-17 11:07:06.3357242026-02-17 13:06:30.164557
SBN_to_AWSneocp_prev_des710332026-02-17 11:07:06.3357242026-02-17 13:06:30.268041
MPC_primarydbneocp_var1028602026-02-17 13:05:37.6591022026-02-17 13:06:30.368462
MPC_mpcsbndbneocp_var1028602026-02-17 13:05:37.6591022026-02-17 13:06:30.537771
SBN_to_AWSneocp_var1028602026-02-17 13:05:37.6591022026-02-17 13:06:30.655903
MPC_primarydbobscodes26782026-02-10 17:33:01.1559412026-02-17 13:06:30.762257
MPC_mpcsbndbobscodes26782026-02-10 17:33:01.1559412026-02-17 13:06:30.882998
SBN_to_AWSobscodes26782026-02-10 17:33:01.1559412026-02-17 13:06:30.971762
MPC_primarydbprimary_objects15602212026-02-17 11:06:17.1641372026-02-17 13:06:31.062227
MPC_mpcsbndbprimary_objects15602212026-02-17 11:06:17.1641372026-02-17 13:06:31.507698
SBN_to_AWSprimary_objects15602212026-02-17 11:06:17.1641372026-02-17 13:06:31.675109
MPC_primarydbobs_alterations_corrections02026-02-17 13:06:31.865347
MPC_mpcsbndbobs_alterations_corrections02026-02-17 13:06:31.970733
SBN_to_AWSobs_alterations_corrections02026-02-17 13:06:32.057787
MPC_primarydbobs_alterations_deletions14737012026-02-17 10:59:03.2049672026-02-17 13:06:32.148216
MPC_mpcsbndbobs_alterations_deletions14737012026-02-17 10:59:03.2049672026-02-17 13:06:32.630714
SBN_to_AWSobs_alterations_deletions14737012026-02-17 10:59:03.2049672026-02-17 13:06:32.770538
MPC_primarydbobs_alterations_redesignations45152026-01-03 19:19:15.9113422026-02-17 13:06:32.921696
MPC_mpcsbndbobs_alterations_redesignations45152026-01-03 19:19:15.9113422026-02-17 13:06:33.033727
SBN_to_AWSobs_alterations_redesignations45152026-01-03 19:19:15.9113422026-02-17 13:06:33.121748
MPC_primarydbobs_alterations_unassociations5541812026-02-17 07:32:38.7856952026-02-17 13:06:33.2129
MPC_mpcsbndbobs_alterations_unassociations5541812026-02-17 07:32:38.7856952026-02-17 13:06:33.503201
SBN_to_AWSobs_alterations_unassociations5541812026-02-17 07:32:38.7856952026-02-17 13:06:33.638437
[8]ページ先頭
©2009-2026 Movatter.jp