CODEWITHSUNDEEP
mysqldatabasemacospostgresqlcentos
code-8
code-8

Reputation: 58662

Migrate database from MySQL to PostgreSQL via Pgloader in Cent OS

I'm very confused, and don't understand how this has happened. I used pgloader in my Mac OS X to migrate data from MySQL to PostgreSQL database.

Mac OSX

I tried

pgloader mysql://root@localhost/local postgresql://postgres@localhost/portal

I got

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

All tables, and data in within them are imported perfectly.

Cent OS 6.7 (64 bits)

Then, I've SSH into my local VM as [email protected] and run

pgloader mysql://[email protected]/local postgresql://[email protected]/portal

I got

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

Upvotes: 1

Views: 2158

Answers (1)

e4c5
e4c5

Reputation: 53734

I believe you have a corrupt pgloader installation. The download link on http://tapoueh.org/pgloader/download.html from which you appeared to have grabbed the RPM is for Centos 6.4 unfortunately a lot has changed since then.

I recommend that you try the official postgresql YUM repository. Please uninstall the previously installed RPM before you do so. However even this repository has marked pgloader as not fully compatible. So if this option fails you will have no choice but to compile from source.

Upvotes: 1

Related Questions