Installing PGLOADER into Amazon Linux 2015.03 or Centos6

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:
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
sudo yum -y groupinstall “Development Tools”
sudo rpm -Uvh epel-release-6*.rpm
sudo yum install -y sbcl.x86_64
tar xfj sbcl-1.1.14-source.tar.bz2
cd sbcl-1.1.14
./ –with-sb-thread –with-sb-core-compression
sudo sh

  • 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