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

     
     
     Note

     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();