CentOS6 安装pgloader

本文详细介绍如何在CentOS及Amazon Linux环境下安装SBCL及Pgloader,并提供了具体的步骤与命令。Pgloader是一款强大的工具,能够简化从MySQL到PostgreSQL的数据迁移过程。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值