Обсуждение: [PERFORM] out of range error while restore using pgdump
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
Samir Magar <samirmagar8@gmail.com> writes:
> pg_restore: [archiver (db)] COPY failed for table "tcb_test": ERROR:
> "5.40593839802118076e-315" is out of range for type double precision
That's ... weird. I don't have RHEL7 installed to test, but I don't
see any error for that value on RHEL6 or Fedora 25, which ought to
bracket that version.
I suppose your version of strtod() must be refusing to do gradual
underflow, or else you're running on hardware that doesn't do
IEEE-compliant arithmetic. But I didn't think RHEL supported any
such hardware (unless maybe it's s/390?). And I can't find any
documentation suggesting that glibc supports turning off gradual
underflow, either.
Perhaps you're using some extension that fools around with the
hardware floating-point options?
regards, tom lane