Date: Wed, 21 Aug 2024 11:32:27 +0200
From: Christoph Berg <myon@debian.org>
To: debian-devel <debian-devel@lists.debian.org>,
	PostgreSQL in Debian <pgsql-pkg-debian@lists.postgresql.org>
Subject: Re: The end of 32-bit PostgreSQL support in Debian
Message-ID: <ZsW0K2y4i_Pj5fGR@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	debian-devel <debian-devel@lists.debian.org>,
	PostgreSQL in Debian <pgsql-pkg-debian@lists.postgresql.org>
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>
 <Zqj_4nlZEqfbQ2aM@msg.df7cb.de>
 <Zr3_tXWr0VQol-VH@msg.df7cb.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <Zr3_tXWr0VQol-VH@msg.df7cb.de>
Archived-At: 
 <https://www.postgresql.org/message-id/ZsW0K2y4i_Pj5fGR%40msg.df7cb.de>
Precedence: bulk

Re: To debian-devel
> it has probably been a decade since I've last seen a PostgreSQL
> installation in the wild on a 32-bit machine. PostgreSQL itself works
> fine there, but more and more extensions are not compatible anymore,
> either deliberately, or (more common) because of subtle bugs in printf
> patterns, double precision values not fitting in a PG Datum, or other
> porting problems. Each time this happens, someone has to go digging
> what's wrong this time, while in reality, there are likely no users at
> all for this PG extension on 32-bit architectures.

A new example for this has just arrived, in pgpool2 4.5.3:

https://pgdgbuild.dus.dg-i.net/job/pgpool2-binaries/architecture=i386,distribution=sid/130/console

10:39:04 snprintf.c:409:1: error: conflicting types for ‘strchrnul’; have ‘const char *(const char *, int)’
10:39:04   409 | strchrnul(const char *s, int c)
10:39:04       | ^~~~~~~~~
10:39:04 In file included from snprintf.c:43:
10:39:04 /usr/include/string.h:286:14: note: previous declaration of ‘strchrnul’ with type ‘char *(const char *, int)’
10:39:04   286 | extern char *strchrnul (const char *__s, int __c)
10:39:04       |              ^~~~~~~~~

64-bit builds are fine.

So we'll definitely proceed with removing 32-bit extensions.

Christoph