Atualização do espelho do MPC

[rcboufleur]

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.