Help Center/
Data Replication Service/
Troubleshooting/
Solutions to Failed Check Items/
Database Parameters/
Checking Whether the lc_monetary Values of the Source and Destination Databases Are the Same
Updated on 2024-11-30 GMT+08:00
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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot
