[FFE] Update PostgreSQL to 9.1, drop 9.0

[Martin Pitt]

In oneiric we introduced PostgreSQL 9.0 (earlier releases had 8.4). However, 9.1 RC1 was released this week, the final is expected to be released in the next few weeks (probably with very few changes). The data format and ABI is absolutely frozen now, i. e. the same rules apply for fixes than for post-release fixes.

I uploaded 9.1 to Debian unstable now, and switched over the metapackages to point to -9.1. I am going to drop postgresql-9.0 from unstable/testing in the next few weeks, once the handful of rdepends has been migrated over. I already discussed that with the individual maintainers of these packages, and we agreed to get this done very quickly.

  http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/2011-August/000570.html

(it only has a few answers, as most of the replies were held in moderation due to having too many CC:s, sorry).

As 9.0 has never been in any Debian or Ubuntu stable release, I would like to drop it completely from Oneiric and move to 9.1. This will be the version that we are going to support in the next LTS, and having one major postgresql version less to maintain would be significantly easier.

In particular, this would mean to sync postgresql-9.1 from sid, plus postgresql-common (which switches over the default version, and otherwise just has a couple of important fixes).

[Martin Pitt (pitti)]

Subscribing Canonical server team for their input.

[Scott Kitterman (kitterman)]

Makes sense. Go for it. I think it would be best done before Beta 1.

[Martin Pitt (pitti)]

Reverse dependencies in main:

Just bacula, can easily be switched over to 9.1 (just like we did for 8.4 -> 9.0, it's just a dependency update). I can commit to uploading this.

Universe has a couple of server-side extensions which need to be updated to 9.1:
pgtap
postgresql-pllua
postgresql-plproxy
postgresql-plsh
skytools

Their Debian maintainers said that these would be updated in Debian soon, so we can just sync them as they land. This is the most risky bit, it might be that we will need to drop an extension if it cannot be built against/isn't available for 9.1 yet.

Aside from above, there are two more packages which have reverse dependencies, but aren't server side extensions:

Package: bucardo
Recommends: postgresql-plperl-8.4 | postgresql-plperl-9.0

-> This looks very questionable, and is probably just a trivial change to "Recommends: postgresql-plperl-9.1". The Debian maintainer is going to look into this.

Package: davical
Depends: [...] postgresql-client-9.0 | postgresql-client-8.4 | postgresql-client-8.3 | postgresql-client-8.2 | postgresql-client-8.1, [..]

This should just be fixed to "Depends: postgresql (>= 8.1)".

I can fix bucardo and davical if this is approved.

[Scott Kitterman (kitterman)]

Seems quite manageable and getting to the version we'll use for LTS makes a lot of sense.

[Dave Walker (davewalker)]

I agree with Scott, my primary interest in regards to postgres is getting exposure in Oneiric in preparation for the LTS. I do not believe any core server interests depend by default on postgres, but is a popular option that many people switch to. I would be interested in knowing if SQLalchemy, Django ORM (and maybe storm?) work well with this new upstream version, I would imagine they do, but it's currently an unknown.

However, this is RC1 with the expectation of final coming out within a few weeks - i'm assuming that there is confidence final GA will be released in suitable time to be included in Oneiric? Or are you thinking that RC1 or RC1+fixes will be shipped by us?

Either way pitti, as the platform expert on postgres; I trust your judgement on what to do. I imagine the Debian maintainer will not be happy maintaining two versions. :)

Shoot for gold.

[Martin Pitt (pitti)]

9.1 final will definitively be in oneiric. Presumably it'll hit between beta 1 and 2.

It will also save users yet another upgrade, they can upgrade from 8.4 straight to 9.1 instead of 8.4 -> 9.0 -> 9.1.

[Martin Pitt (pitti)]

I convert this to a tracking bug and created tasks for all affected packages.

Synced postgresql-9.1 into oneiric, will close this once it's built on all arches and binNEWed.

[Martin Pitt (pitti)]

I'll use the postgresql-9.0 task to track its removal from oneiric.

[Launchpad Janitor (janitor)]

This bug was fixed in the package postgresql-common - 120+bzr1

---------------
postgresql-common (120+bzr1) oneiric; urgency=low

  Upload current Debian bzr head to oneiric.

  * debian/supported-versions: Switch Ubuntu 11.10 to 9.1 (LP: #833684) and
    also preemtively add Ubuntu 12.04 (which will ship with 9.1, too).

postgresql-common (120) unstable; urgency=low

  * PgCommon.pm, cluster_info(): Do not consider external_pid_file
    configuration as valid if it is '(none)'. Fixes test suite regression in
    version 119.
  * debian/supported-versions: Switch to 9.1 as default and testing/unstable
    supported version. This will also cause -server-dev-all to only pull in
    -9.1.
  * PgCommon.pm: Partially revert changes for #606336: postmaster does not
    clean up the PID file when it stops, and it is not world readable, so only
    its absence is a definitive result. If the PID file is present, do the
    port probe to check if it is really running.
 -- Martin Pitt <email address hidden> Thu, 25 Aug 2011 14:19:59 +0200

[Launchpad Janitor (janitor)]

This bug was fixed in the package bacula - 5.0.3-1ubuntu4

---------------
bacula (5.0.3-1ubuntu4) oneiric; urgency=low

  * debian/control: Build against PostgreSQL 9.1 (LP: #833684)
  * debian/control: Drop bacula-director-sqlite migration package, we have
    carried it long enough for upgrading. Drop libsqlite0-dev build
    dependency, so that the old sqlite can drop out of main at some point.
 -- Martin Pitt <email address hidden> Thu, 25 Aug 2011 15:00:36 +0200

[Launchpad Janitor (janitor)]

This bug was fixed in the package davical - 0.9.9.4-1ubuntu1

---------------
davical (0.9.9.4-1ubuntu1) oneiric; urgency=low

  * debian/control: Replace the hardcoded postgresql-client-X.Y dependencies
    with a versioned dependency of the metapackage (just as the Recommends:
    already does for the server). (LP: #833684)
 -- Martin Pitt <email address hidden> Thu, 25 Aug 2011 14:57:50 +0200

[Martin Pitt (pitti)]

Many packages are already updated in Debian and can be synced after 9.1 is published.

[Martin Pitt (pitti)]

pgtap is trivial to fix, I'll do that and send the patch to Debian.

[Martin Pitt (pitti)]

postgresql-pllua (1:0.3.2-4) unstable; urgency=low

  * Rebuild for PostgreSQL 9.1.

[Martin Pitt (pitti)]

postgresql-plproxy (2.2-3) unstable; urgency=low

  * Rebuild for PostgreSQL 9.1.
  * Remove our private pg_buildext copy.

[Martin Pitt (pitti)]

postgresql-plsh (1.3-5) unstable; urgency=low

  * Rebuild for PostgreSQL 9.1.
  * Use debian/control.in.

[Martin Pitt (pitti)]

2011-08-25 16:22:47 INFO Removing candidates:
2011-08-25 16:22:47 INFO postgresql-9.0 9.0.4-1build1 in oneiric
2011-08-25 16:22:47 INFO postgresql-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-9.0-dbg 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-9.0-dbg 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-9.0-dbg 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-9.0-dbg 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-client-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-client-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-client-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-client-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-contrib-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-contrib-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-contrib-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-contrib-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-doc-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-doc-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-doc-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-doc-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-plperl-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-plperl-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-plperl-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-plperl-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-plpython-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-plpython-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-plpython-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-plpython-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-pltcl-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-pltcl-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-pltcl-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-pltcl-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO postgresql-server-dev-9.0 9.0.4-1build1 in oneiric amd64
2011-08-25 16:22:47 INFO postgresql-server-dev-9.0 9.0.4-1build1 in oneiric armel
2011-08-25 16:22:47 INFO postgresql-server-dev-9.0 9.0.4-1build1 in oneiric i386
2011-08-25 16:22:47 INFO postgresql-server-dev-9.0 9.0.4-1build1 in oneiric powerpc
2011-08-25 16:22:47 INFO Removed-by: Martin Pitt
2011-08-25 16:22:47 INFO Comment: moved to postgresql-9...

[Martin Pitt (pitti)]

bucardo (4.4.6-1) unstable; urgency=low

  * Also support PostgreSQL 9.1 as dependency.
  * Imported Upstream version 4.4.6
  * Converted patch system to quilt.

[Launchpad Janitor (janitor)]

This bug was fixed in the package pgtap - 0.25.0-1ubuntu1

---------------
pgtap (0.25.0-1ubuntu1) oneiric; urgency=low

  * debian/control: Build against PostgreSQL 9.1. (LP: #833684)
 -- Martin Pitt <email address hidden> Thu, 25 Aug 2011 18:20:55 +0200

[Martin Pitt (pitti)]

OK, it's all done. Welcome postgresql-9.1 in oneiric!

[Martin Pitt (pitti)]

Forgot a task for p-debversion. This has been uploaded to Debian and is currently waiting for binNEW. Once it's through, we can just sync.

[Martin Pitt (pitti)]

postgresql-debversion synced as well.