How to build pgloader on Windows (or CentOS7)?

Question

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 ?

If anyone reaches this post nowaday, documentation is here https://github.com/dimitri/pgloader — Poutrathor, Mar 15 '19 at 13:34

score 4 · Answer 1 · answered Apr 29 '16 at 11:41

4

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)

answered Apr 29 '16 at 11:41

bilak

4,526
3
35
75

1

but this answer is just for centOS. Where is the part for windows? – Snickbrack Feb 06 '17 at 11:10
2

is there no documentation about pgloader for windows? wtf? – Snickbrack Feb 07 '17 at 08:25
nevermind I am just downloading CentOS for testing purpose in a VM ;) – Snickbrack Feb 07 '17 at 09:00
try to create issue on [github](https://github.com/dimitri/pgloader) or try to contact dimitri dim@tapoueh.org – bilak Feb 07 '17 at 09:30

Snickbrack · Answer 2 · 2017-02-08T08:33:46.690

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:

sudo 'yum install -y git' instead of sudo yum install -y git
for the clone step I had to use git:// instead of https://

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...

How to build pgloader on Windows (or CentOS7)?

2 Answers2