Re: [PERFORM] out of range error while restore using pgdump

2017-01-16 Thread Tom Lane
Samir Magar 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 t

[PERFORM] out of range error while restore using pgdump

2017-01-16 Thread Samir Magar
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 t