karlsangabriel/pgloader Docker 镜像 - 轩辕镜像 | Docker 镜像高效稳定拉取服务

Usage:

docker run --rm --name pgloader karlsangabriel/pgloader: pgloader --debug mysql://root:'mysql-password'@host.docker.internal:3306/voyagerdb postgresql://postgres:'pg-password'@host.docker.internal:5432/voyagerdb

For , see the tags tab.

Alternatively, we can execute pgloader within the docker container using:

pgloader --debug mysql://root:'mysql-password'@host.docker.internal:3306/voyagerdb postgresql://postgres:'pg-password'@host.docker.internal:5432/voyagerdb

NOTE: depending on password, having quotes around it may not work. Simply remove the quotes and try again.

We can also override the "default" MySQL Casting by passing a file to pgloader. For example:

pgloader my-custom-casting.load

Where my-custom-casting.load contains:

LOAD DATABASE
FROM mysql://root:***:3306/myschema1
INTO pgsql://postgres:***:5433/mypgdatabase
 WITH include drop, create tables, no truncate,
      create indexes, reset sequences, foreign keys
  SET maintenance_work_mem to '128MB', work_mem to '12MB',
      search_path to 'myschema1' /* migrate to a specific schema */
 CAST type datetime to timestamptz
           drop default drop not null using zero-dates-to-null,
      type date drop not null drop default using zero-dates-to-null,
      type year to integer,
      type integer to integer drop typemod,
      type int to integer drop typemod
 BEFORE LOAD DO
      $$ create schema if not exists myschema1; $$;

=========================================================================