Samir Magar <samirmagar8@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
