Reputation: 9373
I need to convert some MySQL databases to Postgresql.
I came across the pgloader script, which promises to be the best solution, but coming from a Windows environment I have no idea how to build it.
My server has CentOS7, but I have never compiled anything myself on it, other than with yum
. I just don't know where to start or even how to run the bootstrap-centos7.sh script, which is mentioned in the readme-file.
Did anyone ever compile pgloader on Windows or can provide some clear steps how to build this program on CentOS7 ?
Upvotes: 4
Views: 6070
Reputation: 956
In reference to bilak's answer I have tested his solution and saw some errors and it it still not functional yet.
Following changes needed to be done from my side:
The other things are the same for me. But as soon as I want to execute the ./bootstrap-centos7.sh
I am getting a bunch of error for unavailable servers and stuff.
I will create an issue on this via Github and keep this answer updated...
Upvotes: 0
Reputation: 4932
perhaps you already installed this, but for other people it should be easy:
sudo yum install -y git
git clone https://github.com/dimitri/pgloader.git
cd pgloader
chmod +x ./bootstrap-centos7.sh
sudo ./bootstrap-centos7.sh
make pgloader
after make you can check if pgloader is working by exexuting command ./build/bin/pgloader --help
(from pgloader directory)
Upvotes: 4