我很困惑,不明白这是怎么发生的。我用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
1条答案
按热度按时间bxjv4tth1#
我相信你有一个损坏的pgloader安装。下载链接上的http://tapoueh.org/pgloader/download.html,从那里你似乎已经抓住了转速是为Centos 6. 4不幸的是,很多已经改变了,因为从那时起。
我建议你尝试正式的postgresql YUM repository。请在你这样做之前卸载以前安装的RPM。然而,即使这个仓库已经标记为不完全兼容的pgloader。所以如果这个选项失败,你将别无选择,只能从源代码编译。