Pgloader is a usefull tool to migrate data from Mysql to Postgress with a simple command or Python execution
 
For more information about this useful tool:
– https://pgloader.io
– https://github.com/dimitri/pgloader
 
So basically, I write this post because I want to expand a little the Centos and Amazon Linux information that we can find in the Pgloader Official Page.
 
First of all we need SBCL to be able to compile Pgloader
 

How to install SBCL

  • It is curious because to install SBCL 1.1.14, we need sbcl 1.0.8 to compile sbcl 1.1.14)

sudo yum -y install yum-utils rpmdevtools @development-tools sbcl sqlite-devel zlib-devel
http://www.mikeivanov.com/post/66510551125/installing-sbcl-1-1-on-rhel-centos-systems
sudo yum -y groupinstall “Development Tools”
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
sudo rpm -Uvh epel-release-6*.rpm
sudo yum install -y sbcl.x86_64
wget http://downloads.sourceforge.net/project/sbcl/sbcl/1.1.14/sbcl-1.1.14-source.tar.bz2
tar xfj sbcl-1.1.14-source.tar.bz2
cd sbcl-1.1.14
./make.sh –with-sb-thread –with-sb-core-compression
sudo sh install.sh
cd

  • And finally we need to remove the old version that we used to compile the newer one.

sudo yum remove -y sbcl

  • softlink creation that we need it to compile Pgloader

ln -s /usr/local/bin/sbcl /usr/bin/sbcl
 
 
 

How to install PGLoader

  • After that we can install Pgloader

 
make pgloader
(or make or make make COMPRESS_CORE=no)

  • In Debian we use the next >> apt-get install sbcl unzip libsqlite3-dev make curl gawk freetds-dev libzip-dev

 

  • So in Amazon Linux or Centos6 we use:

yum install unzip make curl gawk libzip-devel
yum install freetds-devel.x86_64 yum install freetds.x86_64
yum install openssl-devel openssl
cd /path/to/pgloader
make pgloader
./build/bin/pgloader –help