是否有人让pgloader为从Mysql迁移到Postgres而工作？

Question

我已经在centos 6.5上使用yum安装了pg加载程序。我无法让pgloader加载以下文件。我在shell上的命令是pgloader mysql.load。

 LOAD DATABASE
 from      mysql://root:pass123@127.0.0.1:7777/demomysql
 into postgresql://postgres:postgres@127.0.0.1:5432/dbname?demopsql

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 'demopsql'

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

-- MATERIALIZE VIEWS film_list, staff_list

-- INCLUDING ONLY TABLE NAMES MATCHING ~/film/, 'actor'
-- EXCLUDING TABLE NAMES MATCHING ~<ory>

BEFORE LOAD DO
$$ create schema if not exists demopsql; $$;

我得到以下日志文件

 pgloader     INFO     Logger initialized
 pgloader     WARNING  path entry '/usr/share/python-support/pgloader/reformat' does not        exists, ignored
 pgloader     INFO     Reformat path is [] 
 pgloader     INFO     Will consider following sections:
 pgloader     INFO       
 pgloader     INFO     All threads are started, wait for them to terminate

Answer 1

这一警告是由于一个错误造成的。

在/usr/ DEFAULT_REFORMAT_PATH /pyshared/pgloader/options.py中搜索变量

将给定的路径替换为

/usr/share/pyshared/reformat。

文件上也有一个错误: dbname?demopsql应该是demopsql。