How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
От | Hilbert, Karin |
---|---|
Тема | How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? |
Дата | |
Msg-id | MN2PR02MB6829258E28420A40E699FB0289869@MN2PR02MB6829.namprd02.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? |
Список | pgsql-general |
5,6c5,6
< -- Dumped from database version 9.6.23
< -- Dumped by pg_dump version 9.6.23
---
> -- Dumped from database version 12.8
> -- Dumped by pg_dump version 12.8
34085c34085
< xxxxxxxx xxxxxxxx xxx P 108 xxxxxxx UP FI xxxx-xx-xx 53809.6016 53809.6016 52W 0 xxx 0 xxxxx \N
---
> xxxxxxxx xxxxxxxx xxx P 108 xxxxxxx UP FI xxxx-xx-xx 53809.6 53809.6 52W 0 xxx 0 xxxxx \N
34088c34088
< xxxxxxxx xxxxxxxx xxx P 108 xxxxxxx UP FI xxxx-xx-xx 53809.6016 53809.6016 52W 0 xxx 0 xxxxx \N
---
> xxxxxxxx xxxxxxxx xxx P 108 xxxxxxx UP FI xxxx-xx-xx 53809.6 53809.6 52W 0 xxx 0 xxxxx \N
… ß data is truncated in new database
147825,147826c147825,147826
< xxxxxxxx \N \N \N 46716.8008 \N \N \N \N \N \N \N
< xxxxxxxx \N \N \N 38729.6016 \N \N \N \N \N \N \N
---
> xxxxxxxx \N \N \N 46716.8 \N \N \N \N \N \N \N
> xxxxxxxx \N \N \N 38729.6 \N \N \N \N \N \N \N
Table "tablex"
Column | Type | Modifiers
------------------+----------------------+-----------
id | integer | not null
column2 | character(8) | not null
column3 | character(3) | not null
column4 | character(1) |
column5 | character(4) |
column6 | character(10) |
column7 | character(2) |
column8 | date |
column9 | real |
column10 | real |
id | column9 | column10
------------+--------------+------------------
xxxxxxxx | 53809.6 | 53809.6
(1 row)
xxxxxxxx 19.8199997 \N \N 3435 \N 1 \N \N \N 3435 0 0
3435 \N \N \N 0
…
xxxxxxxx 25.8700008 \N \N 4484.12988 80 \N \N \N \N 2069.6001
0 0 2069.6001 \N \N \N 0 vs.
xxxxxxxx 19.82 \N \N 3435 \N 1 \N \N \N 3435 0 0 3435
\N \N \N 0
…
xxxxxxxx 25.87 \N \N 4484.13 80 \N \N \N \N 2069.6 0 0 2069.6 \N \N \N 0
В списке pgsql-general по дате отправления:
Предыдущее
От: "Ryan, Les"Дата:
Сообщение: RE: WAL File Recovery on Standby Server Stops Before End of WAL Files