Configuration Method for a Synchronization Task from GaussDB Distributed in Single-Task Mode

Procedure

1. Log in to all nodes of the distributed GaussDB instance.
2. Query the location of the configuration file.

   find / -name "pg_hba.conf"

3. Open the pg_hba.conf file. Retain sha256 and insert trust of the specified single-mode task user in the line above sha256.
   • CN configuration
     host replication <user> 0.0.0.0/0 sha256

     Figure 1 CN configuration
     
   • DN configuration

     host replication <user> 0.0.0.0/0 trust

     Figure 2 DN configuration
     
     

     For the DN configuration, do not set <User> to all. Otherwise, connections to DNs on a distributed source instance in multi-task mode will be affected.

4. Run the following statement as a system administrator on the source database or restart the DB instance to apply the change:

   select pg_reload_conf();