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
- Failure Cause
- Handling Suggestion