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

 

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)