Install

Debian GNU/Linux and Ubuntu

Supported versions:

• Debian GNU/Linux bookworm

• Ubuntu 22.04 LTS

Enable the PostgreSQL APT repository:

sudo apt update
sudo apt install -y ca-certificates gpg lsb-release wget
wget -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
  sudo gpg --no-default-keyring --keyring /usr/share/keyrings/pgdg.gpg --import -
(echo "Types: deb"; \
 echo "URIs: http://apt.postgresql.org/pub/repos/apt"; \
 echo "Suites: $(lsb_release --codename --short)-pgdg"; \
 echo "Components: main"; \
 echo "Signed-By: /usr/share/keyrings/pgdg.gpg") | \
  sudo tee /etc/apt/sources.list.d/pgdg.sources

Enable the Apache Arrow APT repository:

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
sudo apt install -y -V ./apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb
rm apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb
sudo apt update

Install postgresql-15-pgdg-apache-arrow-flight-sql:

sudo apt install -y postgresql-15-pgdg-apache-arrow-flight-sql

See Configuration how to configure Apache Arrow Flight SQL adapter for PostgreSQL.

Source

You need to install the followings before you build Apache Arrow Flight SQL adapter for PostgreSQL:

• PostgreSQL 15 or later: https://www.postgresql.org/download/

• Apache Arrow C++ with Flight SQL support: https://arrow.apache.org/install/

• Meson: https://mesonbuild.com/

• Ninja: https://ninja-build.org/

• C++ compiler such as g++ and `clang++

Here are command lines to build Apache Arrow Flight SQL adapter for PostgreSQL:

Note

Replase ${version} with 0.1.0 or define version variable with 0.1.0.

wget "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
sudo meson install -C apache-arrow-flight-sql-postgresql-${version}.build

See Configuration how to configure Apache Arrow Flight SQL adapter for PostgreSQL.