pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedout of range error while restore using pgdump
2+ messages / 2 participants
[nested] [flat]
* out of range error while restore using pgdump
@ 2017-01-16 09:20 Samir Magar <samirmagar8@gmail.com>
2017-01-16 15:30 ` Re: out of range error while restore using pgdump Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Samir Magar @ 2017-01-16 09:20 UTC (permalink / raw)
To: pgsql-performance; +Cc: Swapnil Vaze <swapvaze28@gmail.com>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: out of range error while restore using pgdump
2017-01-16 09:20 out of range error while restore using pgdump Samir Magar <samirmagar8@gmail.com>
@ 2017-01-16 15:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2017-01-16 15:30 UTC (permalink / raw)
To: Samir Magar <samirmagar8@gmail.com>; +Cc: pgsql-performance@postgresql.org, Swapnil Vaze <swapvaze28@gmail.com>
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-01-16 15:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-01-16 09:20 out of range error while restore using pgdump Samir Magar <samirmagar8@gmail.com>
2017-01-16 15:30 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox