Remove NBS 32-bit postgresql extension packages, part 5

[Adrien Nader]

This is a follow-up to #208800{3,4,5,6} as I've identified a few more affected packages.

I'm copying Jeremy's original description at the end of this description.

The affected packages are:

- pgpointcloud
- pgnodemx
- pgmemcache
- pglogical
- pgfincore
- pgextwlist
- mobilitydb

I ran the following to check for reverse-dependencies:

for p in pgpointcloud pgnodemx pgmemcache pglogical pgfincore pgextwlist mobilitydb; do
(reverse-depends -a armhf -r plucky -R -l src:${p}; reverse-depends -a armhf -r plucky -R -l -b src:${p}) | grep . && echo $p
done

Only pglogical has reverse-dependencies:

- pgl-ddl-deploy: source package, asked for removal in #2088006
- pglogical-ticker: source package, asked for removal in #2088006
- postgresql-16-pglogical-ticker: binary package, which source is pglogical-ticker above

There is a special package: mobilitydb which is a new package and never got out of proposed (also postgresql even if it's not in the name).

Jeremy's description:

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

[Steve Langasek (vorlon)]

$ remove-package -a armhf -b -m "64-bit only, ANAIS; LP: #2089236" -y postgresql-16-pointcloud
Removing packages from plucky:
 postgresql-16-pointcloud 1.2.5-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2089236
1 package successfully removed.
$

[Steve Langasek (vorlon)]

mobilitydb not published in the release pocket.

[Steve Langasek (vorlon)]

$ remove-package -a armhf -b -m "64-bit only, ANAIS; LP: #2089236" -y postgresql-16-pgextwlist
Removing packages from plucky:
 postgresql-16-pgextwlist 1.17-2 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2089236
1 package successfully removed.
$

[Steve Langasek (vorlon)]

$ remove-package -a armhf -b -m "64-bit only, ANAIS; LP: #2089236" -y postgresql-16-pgfincore
Removing packages from plucky:
 postgresql-16-pgfincore 1.3.1-1 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2089236
1 package successfully removed.
$

[Steve Langasek (vorlon)]

> reverse-depends -a armhf -r plucky -R -l -b src:${p}

I don't trust `reverse-depends -a $arch -b`, it's basically an incoherent set of arguments. I use `-a source` instead, and I double-checked for these packages here:

$ reverse-depends -a source -l src:pglogical
pgl-ddl-deploy
pglogical-ticker
$

And a check confirms that these packages still build binaries on armhf:

$ rmadison -s plucky,plucky-proposed -S pglogical-ticker pgl-ddl-deploy
 pglogical-ticker | 1.4.1-7 | plucky/universe | source
 pglogical-ticker | 1.4.1-8 | plucky-proposed/universe | source
 postgresql-16-pglogical-ticker | 1.4.1-7 | plucky/universe | amd64, arm64, armhf, ppc64el, riscv64, s390x
 postgresql-17-pglogical-ticker | 1.4.1-8 | plucky-proposed/universe | amd64, arm64, ppc64el, riscv64, s390x
 pgl-ddl-deploy | 2.2.1-1 | plucky/universe | source
 pgl-ddl-deploy | 2.2.1-2 | plucky-proposed/universe | source
 postgresql-16-pgl-ddl-deploy | 2.2.1-1 | plucky/universe | amd64, arm64, armhf, ppc64el, riscv64, s390x
 postgresql-17-pgl-ddl-deploy | 2.2.1-2 | plucky-proposed/universe | amd64, arm64, ppc64el, riscv64, s390x
$

I'm assuming we'll want to remove these binaries too, but can you please check them over?

[Steve Langasek (vorlon)]

$ remove-package -a armhf -b -m "64-bit only, ANAIS; LP: #2089236" -y postgresql-16-pgmemcache
Removing packages from plucky:
 postgresql-16-pgmemcache 2.3.0-13build2 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2089236
1 package successfully removed.
$

[Steve Langasek (vorlon)]

$ remove-package -a armhf -b -m "64-bit only, ANAIS; LP: #2089236" -y postgresql-16-pgnodemx
Removing packages from plucky:
 postgresql-16-pgnodemx 1.6-2 in plucky armhf
Comment: 64-bit only, ANAIS; LP: #2089236
1 package successfully removed.
$

[Adrien Nader (adrien)]

Hmm, duh, thanks for pointing out the bad -a and -b combination. I need to get the habit of avoiding -b completely.

I checked the packages which depend upon pglogical:

- pglogical-ticker: source, restricted to 64-bit arches
  - postgresql-17-pglogical-ticker: binary missing in proposed, sole package built from it
    NB: pg-fact-loader build-depends on it but has been removed from armhf in https://bugs.launchpad.net/ubuntu/+source/pg-auto-failover/+bug/2088004 ("part 2" of the bug series)
  - postgresql-16-pglogical-ticker: binary in release, sole package previously built from pglogical-ticker
- pgl-ddl-deploy: source, restricted to 64-bit arches
  - postgresql-17-pglogical-ticker: binary missing in proposed, sole package built from it
  - postgresql-16-pglogical-ticker: binary in release, sole package previously built from pglogical-ticker

[Adrien Nader (adrien)]

Note that pglogical-ticker and pgl-ddl-deploy are listed in https://bugs.launchpad.net/ubuntu/+source/pgrouting/+bug/2088006 so I'm not touching the bug here.