out of range error while restore using pgdump

From: Samir Magar <samirmagar8(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Swapnil Vaze <swapvaze28(at)gmail(dot)com>
Subject: out of range error while restore using pgdump
Date: 2017-01-16 09:20:30
Message-ID: CAA=to3iNVdwLnT6sh-5ubwG_-2FASE0yzkERV9XsO69UsCjk9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2017-01-16 15:30:40 Re: out of range error while restore using pgdump
Previous Message Stuart Bishop 2017-01-13 11:48:35 Re: Sort-of replication for reporting purposes