Forcibly Stopping Synchronization of GaussDB Primary/Standby

Prerequisites

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

Procedure

1. Log in to the GaussDB primary/standby instance as the user used when you tested connectivity between the DRS instance and the GaussDB primary/standby 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.