journeytosilius commented on issue #193:
URL:
https://github.com/apache/arrow-flight-sql-postgresql/issues/193#issuecomment-2567664558
Also, I tried to install the package instead of building from source, but
it's not there anymore ( it's deleted or archived ). Tried to download it
manually to add it to the docker image, but could not find it.
```
FROM ubuntu:24.04
RUN set -ex; \
apt-get update && apt-get install -y -V \
ca-certificates \
lsb-release \
wget \
gnupg \
postgresql-common \
apt-transport-https \
cmake \
build-essential \
libkrb5-dev \
&& wget https://apache.jfrog.io/artifactory/arrow/$(lsb_release --id
--short | tr 'A-Z' 'a-z')/apache-arrow-apt-source-latest-$(lsb_release
--codename --short).deb \
&& apt-get install -y -V ./apache-arrow-apt-source-latest-$(lsb_release
--codename --short).deb \
&& apt-get clean
# Add PostgreSQL APT repository and key manually (bypass interactive script)
RUN echo "deb https://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c
-s)-pgdg main" | tee /etc/apt/sources.list.d/pgdg.list \
&& wget --quiet -O -
https://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | tee
/etc/apt/trusted.gpg.d/pgdg.asc
RUN echo "deb https://packagecloud.io/timescale/timescaledb/ubuntu/
$(lsb_release -c -s) main" | tee /etc/apt/sources.list.d/timescaledb.list
RUN wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey |
gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
RUN apt update
RUN apt install -y postgresql-server-dev-17
# Set noninteractive environment to prevent timezone prompts
ENV DEBIAN_FRONTEND=noninteractive
RUN apt-get install -y timescaledb-2-postgresql-17='2.17.0*'
timescaledb-2-loader-postgresql-17='2.17.0*' postgresql-client-17
# Install Apache Arrow and related libraries
RUN set -ex; \
apt-get update && apt-get install -y -V \
libarrow-dev \
libarrow-glib-dev \
libarrow-dataset-dev \
libarrow-dataset-glib-dev \
libarrow-acero-dev \
libarrow-flight-dev \
libarrow-flight-glib-dev \
libarrow-flight-sql-dev \
libarrow-flight-sql-glib-dev \
libgandiva-dev \
libgandiva-glib-dev \
libparquet-dev \
libparquet-glib-dev \
postgresql-15-pgdg-apache-arrow-flight-sql \
&& apt-get clean
# Download and build Apache Arrow Flight SQL adapter for PostgreSQL
ARG version=0.1.0
RUN wget -O apache-arrow-flight-sql-postgresql-${version}.tar.gz
"https://www.apache.org/dyn/closer.lua?action=download&filename=arrow/apache-arrow-flight-sql-postgresql-${version}/apache-arrow-flight-sql-postgresql-${version}.tar.gz";
\
&& tar xfv apache-arrow-flight-sql-postgresql-${version}.tar.gz \
&& meson setup \
--prefix=/usr/local \
-Dpostgresql_dir=$(pg_config --bindir)/.. \
apache-arrow-flight-sql-postgresql-${version}.build \
apache-arrow-flight-sql-postgresql-${version} \
&& meson compile -C apache-arrow-flight-sql-postgresql-${version}.build \
&& meson install -C apache-arrow-flight-sql-postgresql-${version}.build
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
