Re: Does PGDG apt repository support ARM64?

On 3/31/22 18:22, Daniele Varrazzo wrote:
> Hello,
>
> Psycopg binary files are built on Debian Stretch images. I have
> noticed that, on arm64 platforms, even if the pgdg apt repository is
> configured, apt-get will install libpq 9.6 (from the Debian
> repository), not the 14 available in pgdg. As a result, certain
> features are not available on psycopg[binary] on the arm platform,
> such as SCRAM authentication.
>
> This is the latest version of the libpq installation script [1] and
> its log, resulting in the installation of libpq-dev 9.6 [2]. On all
> the other supported platforms, libpq is installed from pgdg, see [3]
> for an amd64 run.
>
> The installation procedure in the latest run was pretty much:
>
> source /etc/os-release
> echo "deb http://apt.postgresql.org/pub/repos/apt
> $VERSION_CODENAME-pgdg main" \
> > /etc/apt/sources.list.d/pgdg.list
> curl -skf https://www.postgresql.org/media/keys/ACCC4CF8.asc \
> > /etc/apt/trusted.gpg.d/postgresql.asc
>
> cat > /etc/apt/preferences.d/pgdg.pref <<HERE
> Package: *
> Pin: release o=apt.postgresql.org
> Pin-Priority: 500
> HERE
>
> apt-get update
> apt-get -y upgrade
> apt-get -y install libpq-dev
>
> Are arm packages available at all? If so, what is the right procedure
> to install them?

From here:

https://apt.postgresql.org/pub/repos/apt/dists/

I see them in Debian:

Buster on up

Ubuntu

Focal on up, except Impish.

>
> Cheers
>
> -- Daniele
>
> [1]: https://github.com/psycopg/psycopg/blob/70e58346913f014fd6f30a541b375e224c1885f5/tools/build/wheel_linux_before_all.sh#L19
> [2]: https://github.com/psycopg/psycopg/runs/5780379688?check_suite_focus=true#step:6:365
> [3] https://github.com/psycopg/psycopg/runs/5744603160?check_suite_focus=true#step:6:247
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com