Migrate database from MySQL to PostgreSQL via Pgloader in Cent OS
<p>I'm very confused, and don't understand how this has happened. I used <a href="http://pgloader.io/" rel="nofollow noreferrer">pgloader</a> in my Mac OS X to migrate data from MySQL to PostgreSQL database.</p>
<h1>Mac OSX</h1>
<p>I tried</p>
<p><code>pgloader mysql://root@localhost/local postgresql://postgres@localhost/portal</code></p>
<p>I got</p>
<pre><code>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 &quot;mirror_settings&quot; 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
</code></pre>
<p>All tables, and data in within them are imported <strong>perfectly</strong>.</p>
<hr />
<h1>Cent OS 6.7 (64 bits)</h1>
<p>Then, I've SSH into my local VM as root@172.16.139.1 and run</p>
<p><code>pgloader mysql://root@172.16.139.1/local postgresql://postgres@172.16.139.130/portal</code></p>
<p>I got</p>
<pre><code>debugger invoked on a SIMPLE-ERROR in thread
#&lt;THREAD &quot;main thread&quot; RUNNING {10070AB033}&gt;:
  Error opening shared object &quot;libssl.so.1.0.0&quot;:
  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&quot;libssl.so.1.0.0&quot; :NAMESTRING &quot;libssl.so.1.0.0&quot; :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
</code></pre>