Table copy

Поиск
Список
Период
Сортировка
От Andy Hartman
Тема Table copy
Дата
Msg-id CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table copy
Список pgsql-general
I'm copying a large table from mssql to PG using SImplysql and in the Log I see this message

2025-02-04 14:42:17.975 EST [4796] ERROR:  unexpected EOF on client connection with an open transaction
2025-02-04 14:42:17.975 EST [4796] CONTEXT:  COPY sqlt_data_1_2022_03, line 208274199, column tagid
2025-02-04 14:42:17.975 EST [4796] STATEMENT:  COPY sqlt_data_1_2022_03 (tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity, t_stamp) FROM STDIN (FORMAT BINARY)
2025-02-04 14:42:18.158 EST [4796] FATAL:  terminating connection because protocol synchronization was lost
2025-02-04 14:42:18.265 EST [4796] LOG:  could not send data to client: An established connection was aborted by the software in your host machine.

it then dies with a data stream error.I have copied other tables on this size with no problems.

 THanks.


В списке pgsql-general по дате отправления: