[PERFORM] out of range error while restore using pgdump

Поиск
Список
Период
Сортировка
От Samir Magar
Тема [PERFORM] out of range error while restore using pgdump
Дата
Msg-id CAA=to3iNVdwLnT6sh-5ubwG_-2FASE0yzkERV9XsO69UsCjk9w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PERFORM] out of range error while restore using pgdump
Список pgsql-performance
Hello,
We are migrating database from one server to another.
As such we are not making any changes in the database structure.
Stil getting below error while restore using pgdump.


pg_restore: [archiver (db)] COPY failed for table "tcb_test": ERROR:  "5.40593839802118076e-315" is out of range for type double precision
CONTEXT:  COPY tcb_test, line 3932596, column va_odometro: "5.40593839802118076e-315"

Could you please help us how can we avoid solve this error?

postgres version 9.5 
OS: Red hat 7.1

Thanks,
Samir Magar

В списке pgsql-performance по дате отправления:

Предыдущее
От: Stuart Bishop
Дата:
Сообщение: Re: [PERFORM] Sort-of replication for reporting purposes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] out of range error while restore using pgdump