Postgres Pro
Downloads
Home   >   mailing lists

Table copy - Mailing list pgsql-general

From Andy Hartman
Subject Table copy
Date
Msg-id CAEZv3cqo3rze3SQUqLCNq7gbnQiDusCD4R+55UW3VtuZZeJQBg@mail.gmail.com
Whole thread Raw
Responses Re: Table copy
List pgsql-general
Tree view
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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Lookup tables
Next
From: Adrian Klaver
Date:
Subject: Re: Table copy