nav-img
Advanced

Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same

During PostgreSQL synchronization, check whether the lc_monetary values of the source and destination databases are the same. If they are inconsistent, the synchronization fails.

Failure Cause

The lc_monetary values of the source and destination databases are different.

Handling Suggestion

Change the value of lc_monetary.

  • For a self-managed database, run the following command to change the value.
    SET lc_monetary TO ='Currency format'
  • For an RDS for PostgreSQL instance, change the parameter by referring to "Modifying Parameters of an RDS for PostgreSQL Instance".