Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] out of range error while restore using pgdump - Mailing list pgsql-performance

From Samir Magar
Subject [PERFORM] out of range error while restore using pgdump
Date
Msg-id CAA=to3iNVdwLnT6sh-5ubwG_-2FASE0yzkERV9XsO69UsCjk9w@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORM] out of range error while restore using pgdump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: [PERFORM] Sort-of replication for reporting purposes
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] out of range error while restore using pgdump