Answer the question
In order to leave comments, you need to log in
How to restore a backup made in version 9.4 in Postgresql 9.5?
There is a backup made in version 9.4. The database actively uses the money type.
When trying to restore a backup in version 9.5, a bunch of errors like
Command was: INSERT INTO tbl_1 (col1,col2,col3...
pg_restore: [archiver (db)] could not execute query: °РєСЃРёСЃ для типа money: "86В 917.09СЂ."
LINE 1: ...NULL, NULL, NULL, NULL, '86В 917.09...
In other words, wherever there is a non-null value of type money In the changelog there is no mention of changing the type of
money.In
version 9.4, the same backup is restored without problems.Tell
me what is the mistake and where to dig?
Answer the question
In order to leave comments, you need to log in
The text of your error is as follows:
ERROR: invalid syntax for type
I think you have problems with localizations, in numeric value instead of comma, etc.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question