From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PG8.3->10 migration data differences |
Date: | 2018-09-10 08:57:42 |
Message-ID: | b7e21ca6-c795-2cda-4873-ae8cd80383a8@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/09/2018 11:22, Csaba Ragasits wrote:
> Hello,
>
> We would like to migrate our old databases to new postgres server, with the simple backup-restore process. The process run fine without errors but when we're checking the source and the migrated
> datas as field level, we found the following differences:
>
> For example:
>
> Field type: TIMESTAMP WITHOUT TIME ZONE NOT NULL
> pg93: 2015-08-28 21:25:07.70
> pg10: 2015-08-28 21:25:07.7
Those two are absolutely the same value. 7/10 = 70/100
>
> Field type: REAL
> pg93: 2.2
> pg10: 2.20000005
>
Those have to do with rounding. Precision for real is 6 decimal digits. Your difference is on the 8-th digit.
> When I check the 8.3 pg_dump file, it contains the pg83 correct values.
>
> Do you have any ideas, why different this values?
>
> Thx,
> Csaba
>
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2018-09-10 10:00:40 | Re: PG8.3->10 migration data differences |
Previous Message | Csaba Ragasits | 2018-09-10 08:22:20 | PG8.3->10 migration data differences |