L
L
Lumad2016-01-14 12:30:07
PostgreSQL
Lumad, 2016-01-14 12:30:07

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

1 answer(s)
A
Andrey Mokhov, 2016-01-14
@Lumad

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 question

Ask a Question

731 491 924 answers to any question