[Pkg-postgresql-public] PostgreSQL 9.1 support in jessie?

[Daniel Pocock]

On 24/09/13 08:38, Daniel Pocock wrote:
>
> On 24/09/13 07:54, Martin Pitt wrote:
>> Daniel Pocock [2013-09-23 19:20 +0200]:
>>> I'm just wondering about the status of PostgreSQL 9.1 for jessie, will
>>> it still be included?
>> No, as usual we will only support one major version in each Debian
>> release, which will be 9.3. We will remove 9.1 soon, and rebuild all
>> extensions against 9.3, and only keep older versions on
>> apt.postgresql.org.
>>
>> 9.1 is already quite old, and won't be supported upstream long enough
>> for jessie's lifetime.
>>
>>> The recently uploaded PostBooks packages don't work with 9.3 and
>>> upstream's compatibility matrix doesn't mention 9.3 yet:
>> Hmm, if that is a recent project, why has it been developed against a
>> rather old PostgreSQL? At least 9.2 has been around for 1.5 years now.
> I suspect that as it is a business software application they are
> supporting users who have RHEL6 or Ubuntu LTS.  Those platforms seem to
> be allowing people to run existing PostgreSQL server versions for 5
> years or more
>
>> There's still plenty of time to get it ported to 9.3, though, jessie
>> only just started.
> We're tracking this issue now, I'll follow up with upstream
>
>



I just had a closer look at the situation:

RHEL6/CentOS6 (which is getting old, RHEL7 is coming next year?) has
PostgreSQL 8.4

Red Hat "Software Collections", described on ZDNet, is offering
PostgreSQL 9.2 and appears to be a preview of what will come in RHEL7. 
One post appeared on Planet PostgreSQL making a similar prediction.

Ubuntu 12.04 LTS has both PostgreSQL 8.4 and 9.1

This leaves me feeling that developers of some business applications are
likely to favor those versions (9.1 or 9.2) and may not update to v9.3
as quickly as Debian would hope, for example, activity on xTuple's
forums suggests Ubuntu LTS is popular there.

Apart from the procpid issue, are there likely to be many other painful
issues with migrating apps?

Given that concurrent versions are supported on Debian, is there any
hope of keeping 9.1 as an option for people who want to build Debian
systems that are more in sync with commercial distributions?