Forcibly Stopping Synchronization of GaussDB(for openGauss) Distributed

Prerequisites

Common users do not have the permission to perform the execute direct operation. To delete streaming replication slots, contact GaussDB(for openGauss) O&M personnel.

Procedure

1. Log in to each primary DN node of GaussDB(for openGauss) distributed instance as the user used when you tested the connectivity between the DRS instance and the GaussDB(for openGauss) distributed instance.
2. Run the following statement to query the streaming replication slot name of the database object selected for the synchronization task:

   select slot_name from pg_replication_slots where database = 'database';

   

   In the preceding command, database indicates the database selected in the synchronization task.

3. Run the following statement to delete the streaming replication slot:

   select * from pg_drop_replication_slot('slot_name');

   

   In the preceding command, slot_name indicates the name of the streaming replication slot queried in 2.

4. Run the following statement to check whether the streaming replication slot is successfully deleted:

   select slot_name from pg_replication_slots where database = 'database';

   If the query result is empty, the streaming replication slot is deleted.

5. Repeat the preceding operations to ensure that the streaming replication slot on each primary DN is deleted.