Error build pgloader on CentOS

[farah-mouzaoui]

I can't complie pgloader on centOS 7. I had a version in June which worked very well. i downloaded the latest version and i have build errors

docker build -f Dockerfile.ccl -t pgloader:debian . Sending build context to Docker daemon 22.34MB Step 1/11 : FROM debian:stable-slim as builder ---> 2bb074a4c289 Step 2/11 : RUN apt-get update && apt-get install -y --no-install-recommends bzip2 ca-certificates curl freetds-dev gawk git libsqlite3-dev libssl1.1 libzip-dev make openssl patch time unzip wget cl-ironclad cl-babel && rm -rf /var/lib/apt/lists/* ---> Using cache ---> bad35e45a2aa Step 3/11 : RUN curl -SL https://github.com/Clozure/ccl/releases/download/v1.11.5/ccl-1.11.5-linuxx86.tar.gz | tar xz -C /usr/local/src/ && mv /usr/local/src/ccl/scripts/ccl64 /usr/local/bin/ccl ---> Using cache ---> 20e8cbc757fd Step 4/11 : COPY ./ /opt/src/pgloader ---> Using cache ---> a7b359878b73 Step 5/11 : RUN mkdir -p /opt/src/pgloader/build/bin && cd /opt/src/pgloader && make CL=ccl DYNSIZE=256 clones save ---> Using cache ---> 0d7ec6fac368 Step 6/11 : FROM debian:stable-slim ---> 2bb074a4c289 Step 7/11 : RUN apt-get update && apt-get install -y --no-install-recommends curl freetds-dev gawk libsqlite3-dev libssl1.1 libzip-dev make sbcl unzip && rm -rf /var/lib/apt/lists/* ---> Using cache ---> a07c64247663 Step 8/11 : COPY --from=builder /opt/src/pgloader/build/bin/pgloader /usr/local/bin COPY failed: stat opt/src/pgloader/build/bin/pgloader: file does not exist

I think it's a problem with dependencies !!!!

Thank you for helping

[devrimgunduz]

PostgreSQL YUM repo has pgloader RPMs. You don't need to build it:

yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum -y install epel-release
yum -y install pgloader

@dimitri can you please update docs on front page and add yum repo option there? Please note that this works on RHEL/CentOS 7 only. EPEL 8 does not have SBCL packages, so cannot build it there.

[farah-mouzaoui]

Thank you it's good. Now i have an other error :

$pgloader myConfigFile.conf 2021-01-14T11:05:58.034000Z LOG pgloader version "3.6.2" KABOOM! FATAL error: Undefined alien: "OpenSSL_version_num" An unhandled error condition has been signalled: Undefined alien: "OpenSSL_version_num"

What I am doing here?

Undefined alien: "OpenSSL_version_num"

I don't know what happend. I see the issue #998 but it's not the same context, it's an execuution into docker !!!

Any idea ??

Thank you.

[devrimgunduz]

Update your OS.

yum -y update openssl*

[farah-mouzaoui]

Can you tell me witch version of openssl is required ?

openssl version OpenSSL 1.0.2k-fips 26 Jan 2017

[devrimgunduz]

I built the packages with 1.0.2k-21.el7_9.x86_64.

[ggrrll]

PostgreSQL YUM repo has pgloader RPMs. You don't need to build it:

yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum -y install epel-release
yum -y install pgloader

@dimitri can you please update docs on front page and add yum repo option there? Please note that this works on RHEL/CentOS 7 only. EPEL 8 does not have SBCL packages, so cannot build it there.

thanks! it worked for me on centos 7.9