pgloader getting current datetime in bad format during migration data

33 views Asked by At

I would like to ask, how to fix following error, where pgloader is getting a current datetime in bad format.

My load configuration is following:

LOAD DATABASE
    FROM mysql://root:xxxxxx@localhost:3326/originaldb
    INTO postgresql://postgres:xxxxx@localhost:15432/newdb

WITH data only, include no drop, truncate, disable triggers,
     create no indexes, drop indexes, reset sequences,
     batch rows = 1000, batch size = 500 MB, prefetch rows = 1000

ALTER SCHEMA 'originaldb' RENAME TO 'public'

ALTER TABLE NAMES MATCHING ~/.*/
    SET SCHEMA 'public'

SET timezone TO '+00:00'

SET PostgreSQL PARAMETERS
     maintenance_work_mem to '4096MB',
     work_mem to '2048MB';

During the migration process, I will get following error:

PROTOCOL-ERROR: PostgreSQL protocol error: Unexpected message received: Z 90
An unhandled error condition has been signalled:
   PostgreSQL protocol error: Unexpected message received: Z 90



2024-03-12T02:49:06.768132-04:00 ERROR Date/time: 2024-03-12-07:49!
An unhandled error condition has been signalled:
   PostgreSQL protocol error: Unexpected message received: Z 90

Thanks a lot for en each answer.

enter image description here

0

There are 0 answers