Skip to content

Instantly share code, notes, and snippets.

@twelvejie
Last active July 16, 2024 08:12
Show Gist options
  • Save twelvejie/0044c03d56aae422b48aa7ec579f655b to your computer and use it in GitHub Desktop.
Save twelvejie/0044c03d56aae422b48aa7ec579f655b to your computer and use it in GitHub Desktop.

从 mysql 导出到 pg

# vim my.load
LOAD DATABASE
         FROM      mysql://root:123.123@192.168.1.125:3307/demo_db?useSSL=false
         INTO      postgresql://postgres:123123@@123@192.168.1.125:5432/postgres?demo_db
with prefetch rows = 500
WITH include drop, create tables, create indexes, workers = 1, concurrency = 1
;
# 运行
pgloader my.load
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment