1、 新建文件change.load

2、执行命令

pgloader change.load

3、文件内容 

LOAD DATABASE
     FROM mysql://root:111111@localhost:3306/demo
     INTO postgresql://postgres:root@192.168.2.215:5432/demo
WITH
     include  drop,
     create tables,
     create indexes,
     reset sequences,
     concurrency = 6;

更多推荐