Comment 2 for bug 1954374

Revision history for this message
Christian Ehrhardt  (paelzer) wrote : Re: [RM] Remove src:postgresql-13 from Jammy

Summary on postgresql-13
reverse dependencies are a bit tricky as some binary names transition to the new source (like libpq-dev, libpq5) while others get new versioned names like postgresql-13 -> postgresql-14.

Out of the following we can derive the list of binary packages we need to check:

$ git diff salsa/13 -- debian/control | grep Package
 Package: libpq-dev
 Package: libpq5
 Package: libecpg6
 Package: libecpg-compat3
 Package: libpgtypes3
-Package: postgresql-13
+Package: postgresql-14
-Package: postgresql-client-13
+Package: postgresql-client-14
-Package: postgresql-server-dev-13
+Package: postgresql-server-dev-14
-Package: postgresql-doc-13
+Package: postgresql-doc-14
-Package: postgresql-plperl-13
+Package: postgresql-plperl-14
-Package: postgresql-plpython3-13
+Package: postgresql-plpython3-14
-Package: postgresql-pltcl-13
+Package: postgresql-pltcl-14

That gives us two real dependencies glom and postgresql-13-mysql-fdw

$ for p in postgresql-13 postgresql-client-13 postgresql-server-dev-13 postgresql-doc-13 postgresql-plperl-13 postgresql-plpython3-13 postgresql-pltcl-13; do echo "Check $p"; reverse-depends --release jammy $p; done
Check postgresql-13
Reverse-Depends
* glom [amd64 arm64 armhf ppc64el s390x]
* glom-utils [amd64 arm64 armhf ppc64el s390x]
* postgresql-13-mysql-fdw [amd64 arm64 armhf ppc64el s390x]
* postgresql-plperl-13
* postgresql-plpython3-13
* postgresql-pltcl-13

Packages without architectures listed are reverse-dependencies in: amd64, arm64, armhf, i386, ppc64el, s390x
Check postgresql-client-13
Reverse-Depends
* postgresql-13
* postgresql-server-dev-13

Packages without architectures listed are reverse-dependencies in: amd64, arm64, armhf, i386, ppc64el, s390x
Check postgresql-server-dev-13
No reverse dependencies found
Check postgresql-doc-13
Check postgresql-plperl-13
No reverse dependencies found
Check postgresql-plpython3-13
No reverse dependencies found
Check postgresql-pltcl-13
No reverse dependencies found

Glom should be removed from Jammy as outlined in commend #1.
mysql-fdw needs to be resolved as the new version is stuck in proposed right now.

postgresql-13-mysql-fdw:
     2.5.5-2 500
        500 http://archive.ubuntu.com/ubuntu jammy/universe amd64 Packages
postgresql-14-mysql-fdw:
     2.7.0-1 500
        500 http://archive.ubuntu.com/ubuntu jammy-proposed/universe amd64 Packages