Full Synchronization Error: invalid locale name

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: target engine postgresql client initialize failed, detail: Unable to connect to DBMS: url= %s/position3.0?client_encoding=UTF-8&autosave=always&stringtype=unspecified&ssl=false&sslmode=prefer user= %s, Caused by: ERROR: invalid locale name:'Chinese (Simplified)_China.936'.

Possible Causes

The source database region type is not supported by the destination database.

Solution

Contact the customer to check whether the region type can be changed to another one (UTF-8 by default). The region type may affect the sorting rules of different languages. If it can be changed to UTF-8, submit a service ticket in the upper right corner of the management console.

Parent topic: Real-Time Synchronization from PostgreSQL to PostgreSQL

Previous topic: Full Synchronization Error: Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

Next topic: Full Synchronization Error: password must not equal user name