centos 在Cent OS中通过Pgloader将数据库从MySQL迁移到PostgreSQL

6xfqseft  于 2022-11-07  发布在  Mysql
关注(0)|答案(1)|浏览(407)

我很困惑,不明白这是怎么发生的。我用pgloader在我的Mac OS X中迁移数据从MySQL到PostgreSQL数据库。

Mac OSX操作系统

我试过了
pgloader mysql://root@localhost/local postgresql://postgres@localhost/portal
我得到了

2016-06-15T13:11:23.017000-07:00 LOG Main logs in '/private/tmp/pgloader/pgloader.log'
2016-06-15T13:11:23.060000-07:00 LOG Data errors in '/private/tmp/pgloader/'
2016-06-15T13:11:23.262000-07:00 WARNING PostgreSQL warning: table "mirror_settings" does not exist, skipping
            table name       read   imported     errors            time
----------------------  ---------  ---------  ---------  --------------
       fetch meta data         25         25          0          0.092s
          create, drop          0         26          0          0.217s
----------------------  ---------  ---------  ---------  --------------
                caches          1          1          0          0.156s
       captive_portals          5          5          0          0.074s
              captures          2          2          0          0.029s
      cloud_securities          7          7          0          0.024s
               devices         88         88          0          0.056s
             externals          1          1          0          0.018s
            migrations         52         52          0          0.028s
       mirror_settings          1          1          0          0.036s
         notifications          7          7          0          0.038s
             operators          1          1          0          0.014s
            promotions          5          5          0          0.015s
                 users        224        224          0          0.020s
              visitors         14         14          0          0.013s
Index Build Completion          0          0          0          0.020s
----------------------  ---------  ---------  ---------  --------------
        Create Indexes         12         12          0          0.124s
       Reset Sequences          0         11          0          0.012s
          Primary Keys         11         11          0          0.009s
          Foreign Keys          0          0          0          0.000s
              Comments          0          0          0          0.000s
----------------------  ---------  ---------  ---------  --------------
     Total import time        408        408          0          0.871s

所有表和表中的数据都完美导入。

分操作系统6.7(64位)

然后,我以root@172.16.139.1身份通过SSH登录到本地虚拟机,并运行
pgloader mysql://root@172.16.139.1/local postgresql://postgres@172.16.139.130/portal
我得到了

debugger invoked on a SIMPLE-ERROR in thread

# <THREAD "main thread" RUNNING {10070AB033}>:

  Error opening shared object "libssl.so.1.0.0":
  libssl.so.1.0.0: cannot open shared object file: No such file or directory.

Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

restarts (invokable by number or by possibly-abbreviated name):
  0: [CONTINUE       ] Skip this shared object and continue.
  1: [RETRY          ] Retry loading this shared object.
  2: [CHANGE-PATHNAME] Specify a different pathname to load the shared object from.

(SB-SYS:DLOPEN-OR-LOSE #S(SB-ALIEN::SHARED-OBJECT :PATHNAME #P"libssl.so.1.0.0" :NAMESTRING "libssl.so.1.0.0" :HANDLE NIL :DONT-SAVE NIL))
0] 0
An unhandled error condition has been signalled:
   The value NIL
   is not of type
     (OR (VECTOR CHARACTER) (VECTOR NIL) BASE-STRING PATHNAME STREAM).

; 
; compilation unit aborted
;   caught 1 fatal ERROR condition
bxjv4tth

bxjv4tth1#

我相信你有一个损坏的pgloader安装。下载链接上的http://tapoueh.org/pgloader/download.html,从那里你似乎已经抓住了转速是为Centos 6. 4不幸的是,很多已经改变了,因为从那时起。
我建议你尝试正式的postgresql YUM repository。请在你这样做之前卸载以前安装的RPM。然而,即使这个仓库已经标记为不完全兼容的pgloader。所以如果这个选项失败,你将别无选择,只能从源代码编译。

相关问题