Re: Does PGDG apt repository support ARM64?

Uhm...

I'm not practical with apt repos, but, in the Release file, Buster has:

```
Origin: apt.postgresql.org
Label: PostgreSQL for Debian/Ubuntu repository
Suite: buster-pgdg
Codename: buster-pgdg
Date: Tue, 29 Mar 2022 13:35:36 UTC
Architectures: amd64 arm64 i386 ppc64el

```

whereas Stretch has:

```
Origin: apt.postgresql.org
Label: PostgreSQL for Debian/Ubuntu repository
Suite: stretch-pgdg
Codename: stretch-pgdg
Date: Tue, 29 Mar 2022 13:35:38 UTC
Architectures: amd64 i386 ppc64el
```

Does it mean that there are no arm packages on stretch?

-- Daniele

On Fri, 1 Apr 2022 at 06:07, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> 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