RM: please remove pgloader from jammy (incompatible with PG-14 and FTBFS)

[Christian Ehrhardt ]

Hi,
as part of the postgresql-14 transision (bug 1949579) I was looking into pgloads test fails.
I found that there is more which isn't ready yet.

The package is rather old without updates, the same in G/H/I/J:
https://launchpad.net/ubuntu/+source/pgloader/3.6.2-1

Furthermore a recent no-change rebuild identified it as an FTBFS (on armhf)
https://launchpad.net/ubuntu/+source/pgloader/3.6.2-1build1

In a chat with the Debian postgresql maintainer (Thanks Myon) it became clear that this is broken in regard to postgresql-14 since the new database insists on a more secure scram-sha-256 auth.
But the dependency of cl-pgloader that is cl-postmodern isn't ready for that yet.
A new version of cl-postmodern is in the making but needs cl-global-vars and cl-uax-15 to be ready, both currently held in Debians new queue:
https://qa.debian.org/developer.php?<email address hidden>

In Debian this is ignored, they also had an issue (independent) with the ssl test and then ran a migration-reference/0 which since then makes it not expect a pass.
https://ci.debian.net/packages/p/pgloader/unstable/amd64/

There are no reverse-dependencies at the moment
$ reverse-depends --release jammy src:pgloader
No reverse dependencies found
$ reverse-depends --release jammy --build-depends src:pgloader
No reverse dependencies found

I think removing it now will help to unblock postgresql-14 and once the support for the new cl* packages is ready it will come back to Jammy as a sync.

[Steve Langasek (vorlon)]

Removing packages from jammy:
 pgloader 3.6.2-1 in jammy
  cl-pgloader 3.6.2-1 in jammy amd64
  cl-pgloader 3.6.2-1 in jammy arm64
  cl-pgloader 3.6.2-1 in jammy armhf
  cl-pgloader 3.6.2-1 in jammy i386
  cl-pgloader 3.6.2-1 in jammy ppc64el
  cl-pgloader 3.6.2-1 in jammy riscv64
  cl-pgloader 3.6.2-1 in jammy s390x
  pgloader 3.6.2-1 in jammy amd64
  pgloader 3.6.2-1 in jammy arm64
  pgloader 3.6.2-1 in jammy armhf
Comment: Incompatible with postgresql-14; LP: #1953486
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages from jammy-proposed:
 pgloader 3.6.2-1build1 in jammy
  cl-pgloader 3.6.2-1build1 in jammy amd64
  cl-pgloader 3.6.2-1build1 in jammy arm64
  cl-pgloader 3.6.2-1build1 in jammy armhf
  cl-pgloader 3.6.2-1build1 in jammy i386
  cl-pgloader 3.6.2-1build1 in jammy ppc64el
  cl-pgloader 3.6.2-1build1 in jammy riscv64
  cl-pgloader 3.6.2-1build1 in jammy s390x
  pgloader 3.6.2-1build1 in jammy amd64
  pgloader 3.6.2-1build1 in jammy arm64
Comment: Incompatible with postgresql-14; LP: #1953486
1 package successfully removed.