pg库数据迁移(序列sequence报错,geom报错)

pg库数据迁移(序列sequence报错,geom报错)

geom报错

[ERR] 1> ERROR: type “public.geometry” does not exist
LINE 13: “geom” “public”.“geometry”,
^

[DTF] Process terminated

geom报错解决

是因为没有安装postgis

CREATE EXTENSION postgis;

序列报错解决

1. 创建序列在迁移 可直接运行sql文件

CREATE SEQUENCE pipeline_test_id_seq START 1;