Remove NBS 32-bit postgresql extension packages, part 4

[Jeremy Bícha]

Please remove the postgresql extension packages on armhf since they are no intentionally no longer built.

https://ubuntu-archive-team.ubuntu.com/transitions/html/postgresql-17.html

See https://lists.debian.org/debian-devel/2024/08/msg00202.html for more background

[Adrien Nader (adrien)]

I've found more packages which are affected:

pgpointcloud
pgnodemx
pgmemcache
pglogical
pgfincore
pgextwlist
mobilitydb

I've also noticed the following non-postgres packages which B-D on architecture-is-64-bit

r-bioc-alabaster.base
adios2
mayavi2
pmix
purify
icu-ext
rocr-runtime (but there are other rocr/rocm packages that depend on this and don't have the B-D)
openmpi

I haven't checked reverse dependencies for anything.

[Chris Halse Rogers (raof)]

Seems like there are some extras that should be on the list?

- postgresql-16-pg-fact-loader (reverse Build-Depend of postgresql-16-pglogical-ticker)
- pgq-node (rdepend of postgresql-16-pgq3 from pgq)

And the following needs investigation:
- tinyows (reverse build-depend on postgis, but only a runtime Recommends)

[Steve Langasek (vorlon)]

please show that each of these packages is free of reverse-dependencies in the archive and ready to remove.

[Adrien Nader (adrien)]

I had a look at the packages.

I addressed pgl-ddl-deploy and pglogical-ticker in https://bugs.launchpad.net/ubuntu/+source/pgrouting/+bug/2089236/comments/8 .

I checked the reverse runtime and build dependencies of all other packages.

- pgsphere has a reverse depend from gavodachs2-server which is arch all

- pgq has a reverse depend from pgq-node which is arch all

- postgis has reverse build depends: djangorestframework-gis geoalchemy2 h3-pg osm2pgrouting pgrouting tinyows.
  - djangorestframework-gis is arch all
  - geoalchemy2 is arch all
  - h3-pg was removed in part 1 of this series
  - osm2pgrouting was last uploaded in Debian on 2022-12-01 and has binaries on armhf
  - pgrouting is in this series
  - tinyows: build-depends on postgis and I'm not sure why it's only a Recommends at runtime (maybe because you could make it use a server that isn't local?)

The Description of tinyows contains the following:

    From a technical point of view WFS-T is a Web Service API in front
    of a spatial database. TinyOWS is deeply tied to PostgreSQL/PostGIS
    because of this.

The package is in multiverse and has no reverse (runtime or build) dependency. While it sounds possible to use tinyows on armhf with a postgresql server on another machine, it doesn't sound like an actual scenario.
I'm not entirely sure what happened in debian: I guess that since tinyows only has a runtime Recommends on postgis, nothing got blocked but now the package can't be built from source anymore.
Considering all the above, I think we can do the same, remove postgis, and see in the coming weeks or months if we should add a delta in tinyows to restrict it from 32-bit arches.

[Steve Langasek (vorlon)]

$ src=pgl-ddl-deploy
$ reverse-depends -R -l -a armhf src:$src

$ reverse-depends -l -a source src:$src

$

So this one is clean (and now removed).

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pglogical-ticker 1.4.1-7 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 libpgpool-dev 4.3.7-1ubuntu4 in plucky armhf
 libpgpool2 4.3.7-1ubuntu4 in plucky armhf
 pgpool2 4.3.7-1ubuntu4 in plucky armhf
 postgresql-16-pgpool2 4.3.7-1ubuntu4 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
4 packages successfully removed.

[Steve Langasek (vorlon)]

postgresql-16-pgq-node being arch: all, why has pgq-node not migrated to the release pocket yet as I thought I saw other extensions had done?

Removing packages from plucky:
 postgresql-16-pgq3 3.5-3 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pgrouting 3.6.2-1 in plucky armhf
 postgresql-pgrouting 3.6.2-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
2 packages successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pgsphere 1.5.1-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-asn1oid 1.6-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-http 1.6.0-4 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pgtt 4.0-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pgvector 0.7.4-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-pldebugger 1:1.8-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-plpgsql-check 2.7.8-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-plprofiler 4.2.5-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-plr 1:8.4.7-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-powa 4.2.2-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from plucky:
 postgresql-16-prefix 1.2.10-2 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2088006
1 package successfully removed.