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.

Parent topic:Database Parameters

Previous topic: Checking Whether the Transaction Isolation Levels are Consistent

Next topic: Checking Whether the Source Database Contains Trigger Names with Non-ASCII Characters

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.