search

linea-it / tno

LIneA Occultation Prediction Database
https://solarsystem.linea.org.br
MIT License
1 stars 0 forks source link

Atualização do espelho do MPC #1084

Open rcboufleur opened 1 month ago

rcboufleur commented 1 month ago

Here is a detailed steps:

  1. [MPC] Pause the subscription of mpcweb5 to upper chain.

  2. [SBN] Check that Musforti and Aurora SBN cluster are absolutely synchronized (all latest records in each table are matched).

  3. [You] DROP SUBSCRIPTION your_other_tables_sub;

  4. [You] CREATE SUBSCRIPTION your_other_tables_sub CONNECTION 'host=sbn-am-aurora16-db.cluster-c1t4y1fwdvea.us-east-2.rds.amazonaws.com port=5432 dbname=mpc_sbn user=your_name password=your_password' PUBLICATION sbn146_other_tables_pub WITH (copy_data=false, enabled=true, binary=true);

  5. [You] DROP SUBSCRIPTION your_obs_table_sub;

  6. [You] CREATE SUBSCRIPTION your_obs_table_sub CONNECTION 'host=sbn-am-aurora16-db.cluster-c1t4y1fwdvea.us-east-2.rds.amazonaws.com port=5432 dbname=mpc_sbn user=your_name password=your_password' PUBLICATION sbn146_obs_table_pub WITH (copy_data=false, enabled=true, binary=true);

  7. [MPC] Enable subscription of mpcweb5 to upper chain.