postgres_scanner icon indicating copy to clipboard operation
postgres_scanner copied to clipboard

Failing to load the duckdb extension in aws ecsfargate machine

Open xuanziranhan opened this issue 8 months ago • 0 comments

Hi, we are trying to use duckdb with the postgres extension in aws ecs fargate. But got the following error: Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v1.2.0/linux_amd64_musl/postgres_scanner.duckdb_extension.gz" (HTTP 403) Extension "postgres_scanner" is an existing extension.

We are trying build and load the extensions in code ourselves, by running the following: `apk add g++ git cmake make ninja openssl-dev git clone https://github.com/duckdb/duckdb-postgres.git cd duckdb-postgres git submodule init git pull --recurse-submodules

make`

But it fails because cmake can't use the openssl in the container. Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the system variable OPENSSL_ROOT_DIR (missing: OPENSSL_CRYPTO_LIBRARY) (found version "3.1.8")

Specifying the openssl version didn't work since the alpine version requires this openssl. I wonder if you could support extension for this platform linux_amd64_musl quickly? thanks!

xuanziranhan avatar Feb 21 '25 00:02 xuanziranhan