Re: Does PGDG apt repository support ARM64? - Mailing list pgsql-general

From Daniele Varrazzo
Subject Re: Does PGDG apt repository support ARM64?
Date
Msg-id CA+mi_8atOxHWUiiHjEr4v968bnPtuELkoFdzYHm4SYRh0tKj=Q@mail.gmail.com
Whole thread Raw
In response to Re: Does PGDG apt repository support ARM64?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.klaver@aklaver.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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Does PGDG apt repository support ARM64?
Next
From: Daniele Varrazzo
Date:
Subject: Re: Does PGDG apt repository support ARM64?