[Remove] Please remove postgresql-11 from Focal

Bug #1862601 reported by Christian Ehrhardt 
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
cstore-fdw (Ubuntu)
Fix Released
High
Unassigned
pg-fact-loader (Ubuntu)
Fix Released
Medium
Unassigned
pgl-ddl-deploy (Ubuntu)
Fix Released
Medium
Unassigned
pglogical (Ubuntu)
Fix Released
High
Unassigned
pglogical-ticker (Ubuntu)
Fix Released
Medium
Unassigned
postgresql-11 (Debian)
Fix Released
Unknown
postgresql-11 (Ubuntu)
Fix Released
High
Unassigned

Bug Description

Hi,
together with Debian we want to get rid of Postgresql-11 in future versions.
Currently most importantly in 20.04 before Feature Freeze.

This isn't as clean as we'd have liked it but let me summarize the current case.

Most of the dependencies to postgresql-* are superseded by the new version.
For example `libpq5`, `libpq-dev' and `libecpg6` which make the bulk of the remaining dependencies are provided by src:postgresql-12 now.

What is left is one "context" of packages:
$ reverse-depends -r focal src:postgresql-11 | grep "for postgresql-11"
* postgresql-11-cstore-fdw [amd64 arm64 armhf ppc64el s390x] (for postgresql-11)
* postgresql-11-pg-fact-loader [amd64 arm64 armhf ppc64el s390x] (for postgresql-11)
* postgresql-11-pgl-ddl-deploy [amd64 arm64 armhf ppc64el s390x] (for postgresql-11)
* postgresql-11-pglogical [amd64 arm64 armhf ppc64el s390x] (for postgresql-11)
* there also is pglogical-ticker which doesn't show up here, but depends on it ?!

They seem mostly neglected by upstream:
- postgresql-11-cstore-fdw => https://github.com/citusdata/cstore_fdw/issues/212 (some movement but not ready yet)
- postgresql-11-pg-fact-loader, postgresql-11-pgl-ddl-deploy and pglogical-ticker all depend on postgresql-11-pglogical and that doesn't move (see below)
- postgresql-11-pglogical => https://github.com/2ndQuadrant/pglogical/issues/223

Due to that the removal will have to hit not only src:postgresql-11 but also these packages as they don't get updated as needed to move to postgresql-12. Surely if they react in time before 20.04 release we can try to ship them, but not as-is.

This already happened in Debian via: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=950734
Due to the above this request here is to remove the following from Ubuntu 20.04 (Focal):
- src:postgresql-11
- src:cstore-fdw
- src:pglogical
- src:pglogical-ticker
- src:pg-fact-loader
- src:pgl-ddl-deploy
=> and all binaries formerly built by them

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

Filed to be ready, once wal2json has completed I'll recheck if the other projects responded at all and then we can decide to mark this removal request "active" and subscribe archive admins.

Changed in postgresql-11 (Ubuntu):
importance: Undecided → High
Changed in pglogical-ticker (Ubuntu):
importance: Undecided → Medium
Changed in pgl-ddl-deploy (Ubuntu):
importance: Undecided → Medium
description: updated
Changed in pglogical (Ubuntu):
importance: Undecided → High
Changed in pg-fact-loader (Ubuntu):
importance: Undecided → Medium
Changed in cstore-fdw (Ubuntu):
importance: Undecided → High
Changed in pglogical-ticker (Ubuntu):
status: New → Triaged
Changed in pglogical (Ubuntu):
status: New → Triaged
Changed in pgl-ddl-deploy (Ubuntu):
status: New → Triaged
Changed in pg-fact-loader (Ubuntu):
status: New → Triaged
Changed in cstore-fdw (Ubuntu):
status: New → Triaged
Changed in postgresql-11 (Ubuntu):
status: New → Incomplete
Changed in postgresql-11 (Debian):
status: Unknown → Fix Released
Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

Interim update:
- pglogical has still not responded
- cstore_fdw has replied and seem to work on it, but we can remove now and re-add if they are ready in time (https://github.com/citusdata/cstore_fdw/issues/212)
- wal2json is resolved and the new version in focal doesn't depend on postgresql-11 anymore

Updating the description to take out wal2json there

description: updated
Changed in postgresql-11 (Ubuntu):
status: Incomplete → Triaged
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal:
 cstore-fdw 1.6.2-1ubuntu2 in focal
  postgresql-11-cstore-fdw 1.6.2-1ubuntu2 in focal amd64
  postgresql-11-cstore-fdw 1.6.2-1ubuntu2 in focal arm64
  postgresql-11-cstore-fdw 1.6.2-1ubuntu2 in focal armhf
  postgresql-11-cstore-fdw 1.6.2-1ubuntu2 in focal ppc64el
  postgresql-11-cstore-fdw 1.6.2-1ubuntu2 in focal s390x
Comment: Depends on postgresql-11; LP: #1862601
1 package successfully removed.

Changed in cstore-fdw (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal:
 pg-fact-loader 1.5.2-1 in focal
  postgresql-11-pg-fact-loader 1.5.2-1 in focal amd64
  postgresql-11-pg-fact-loader 1.5.2-1 in focal arm64
  postgresql-11-pg-fact-loader 1.5.2-1 in focal armhf
  postgresql-11-pg-fact-loader 1.5.2-1 in focal ppc64el
  postgresql-11-pg-fact-loader 1.5.2-1 in focal s390x
Comment: Depends on postgresql-11; LP: #1862601
1 package successfully removed.

Changed in pg-fact-loader (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal:
 pgl-ddl-deploy 1.6.0-1ubuntu1 in focal
  postgresql-11-pgl-ddl-deploy 1.6.0-1ubuntu1 in focal amd64
  postgresql-11-pgl-ddl-deploy 1.6.0-1ubuntu1 in focal arm64
  postgresql-11-pgl-ddl-deploy 1.6.0-1ubuntu1 in focal armhf
  postgresql-11-pgl-ddl-deploy 1.6.0-1ubuntu1 in focal ppc64el
  postgresql-11-pgl-ddl-deploy 1.6.0-1ubuntu1 in focal s390x
Comment: Depends on postgresql-11; LP: #1862601
1 package successfully removed.

Changed in pgl-ddl-deploy (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal:
 pglogical 2.2.2-1 in focal
  postgresql-11-pglogical 2.2.2-1 in focal amd64
  postgresql-11-pglogical 2.2.2-1 in focal arm64
  postgresql-11-pglogical 2.2.2-1 in focal armhf
  postgresql-11-pglogical 2.2.2-1 in focal ppc64el
  postgresql-11-pglogical 2.2.2-1 in focal s390x
Comment: Depends on postgresql-11; LP: #1862601
1 package successfully removed.

Changed in pglogical (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal-proposed:
 pglogical-ticker 1.4.0-1 in focal
Comment: FTBFS with postgresql-12; LP: #1862601
1 package successfully removed.

Changed in pglogical-ticker (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Steve Langasek (vorlon) wrote :

Removing packages from focal:
 postgresql-11 11.6-2~sid1build1 in focal
  postgresql-11 11.6-2~sid1build1 in focal amd64
  postgresql-11 11.6-2~sid1build1 in focal arm64
  postgresql-11 11.6-2~sid1build1 in focal armhf
  postgresql-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-11 11.6-2~sid1build1 in focal s390x
  postgresql-client-11 11.6-2~sid1build1 in focal amd64
  postgresql-client-11 11.6-2~sid1build1 in focal arm64
  postgresql-client-11 11.6-2~sid1build1 in focal armhf
  postgresql-client-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-client-11 11.6-2~sid1build1 in focal s390x
  postgresql-doc-11 11.6-2~sid1build1 in focal amd64
  postgresql-doc-11 11.6-2~sid1build1 in focal arm64
  postgresql-doc-11 11.6-2~sid1build1 in focal armhf
  postgresql-doc-11 11.6-2~sid1build1 in focal i386
  postgresql-doc-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-doc-11 11.6-2~sid1build1 in focal s390x
  postgresql-plperl-11 11.6-2~sid1build1 in focal amd64
  postgresql-plperl-11 11.6-2~sid1build1 in focal arm64
  postgresql-plperl-11 11.6-2~sid1build1 in focal armhf
  postgresql-plperl-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-plperl-11 11.6-2~sid1build1 in focal s390x
  postgresql-plpython3-11 11.6-2~sid1build1 in focal amd64
  postgresql-plpython3-11 11.6-2~sid1build1 in focal arm64
  postgresql-plpython3-11 11.6-2~sid1build1 in focal armhf
  postgresql-plpython3-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-plpython3-11 11.6-2~sid1build1 in focal s390x
  postgresql-pltcl-11 11.6-2~sid1build1 in focal amd64
  postgresql-pltcl-11 11.6-2~sid1build1 in focal arm64
  postgresql-pltcl-11 11.6-2~sid1build1 in focal armhf
  postgresql-pltcl-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-pltcl-11 11.6-2~sid1build1 in focal s390x
  postgresql-server-dev-11 11.6-2~sid1build1 in focal amd64
  postgresql-server-dev-11 11.6-2~sid1build1 in focal arm64
  postgresql-server-dev-11 11.6-2~sid1build1 in focal armhf
  postgresql-server-dev-11 11.6-2~sid1build1 in focal ppc64el
  postgresql-server-dev-11 11.6-2~sid1build1 in focal s390x
Comment: Replaced by postgresql-12; LP: #1862601
1 package successfully removed.

Changed in postgresql-11 (Ubuntu):
status: Triaged → Fix Released
Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

Thank you Steve.

In case we search it later to be found from here, the two upstream issues we depend on to bring these dependencies back in (compatible for PG-12 then):
=> https://github.com/2ndQuadrant/pglogical/issues/223
=> https://github.com/citusdata/cstore_fdw/issues/212

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

FYI some of the removed dependencies are ready now and synced back in a postgresql-12 compatible version to make 20.04 complete again.

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

FYI pglogical, cstore-fdw and pg-fact-loader are back.
pglogical-ticker will be back later today.

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

With pg-ddl-deploy we just got back the last removed package.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.