Date: Tue, 30 Jul 2024 17:59:46 +0300
From: Christoph Berg <myon@debian.org>
To: pgsql-pkg-debian@lists.postgresql.org
Subject: Re: The end of 32-bit PostgreSQL support?
Message-ID: <Zqj_4nlZEqfbQ2aM@msg.df7cb.de>
References: 
 <CAOMoQbQak2uyt5oGUaTWHPn3nWo+Q97JWGMWM-bqq6yFWFw+gw@mail.gmail.com>
 <ZqZ1agsCfHd9eRU0@msg.df7cb.de>
 <CABUevEz8tX53wT-1pLXGVSndavCxKBCy47i-5_jpNKtsy7T5cA@mail.gmail.com>
 <4e3e01a0-bc53-45cf-8f53-54781ae28cf4@pgmasters.net>
 <ZqemNrqsjIfuIk9Z@msg.df7cb.de>
 <9BDDFA98-9637-4BC4-BBF6-45CF03DBCD9D@debian.org>
 <EFA87281-1B05-45D0-A814-9C871503542D@thebuild.com>
 <CAOMoQbTdRq4t2hxxi2xMLHE8W-xR2d-XL2AK3WqzH5Eb9YODVg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAOMoQbTdRq4t2hxxi2xMLHE8W-xR2d-XL2AK3WqzH5Eb9YODVg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/Zqj_4nlZEqfbQ2aM%40msg.df7cb.de>
Precedence: bulk

Re: Bradford Boyle
> As a quick reference point, I spent a few minutes looking at how the
> PostgreSQL Yum Repository handles architectures and distributions. It
> looks like when a repo is EOLed, they stop providing updates to any
> package except PostgreSQL RPMs [1]. Additionally, it looks like RHEL 6
> was the last distribution to support x86.

Ack.

> Looking at the current release notes for Debian trixie [2], i686 will
> still be an officially supported architecture. I think the proposal to
> continue building the server, but disable building all extensions for
> 32-bit architectures is very reasonable.

I'd propose this plan:

* Remove buster-pgdg from apt.pg.o (buster-lts was EOLed last month)

* Remove i386 from sid-pgdg (packages are still preserved on
  apt-archive.postgresql.org)

* Upload postgresql-17 to Debian unstable, with all architectures
  supported [*] (once rc1 is there)

* When re-uploading all extensions to Debian to transition them from
  16 to 17, disable extensions on 32-bit archs. Adding this should do
  the trick:

  Build-Depends: architecture-is-64-bit <!pkg.postgresql.32-bit>,

  That way, people could still build extension packages manually if
  they really wanted (dpkg-buildpackage -Ppkg.postgresql.32-bit).

* Remove postgresql-16 from unstable

Christoph

[*] On a side note, 32-bit powerpc did actually start to break:
https://buildd.debian.org/status/logs.php?pkg=postgresql-17&ver=17%7Ebeta2-1&arch=powerpc
I'll tell the package to ignore the regression test results there with
the next postgresql-common upload:
https://salsa.debian.org/postgresql/postgresql-common/-/commit/593fa32fa0c6d2a963a7b3b514d1d6a2423ef534