PostgreSQL 9.1 has had its first release candidate out for some two weeks without major problem reports, so it’s time to promote this more heavily. If you use PostgreSQL, now is the time to try it out and report problems.
We always strive to minimize the number of major versions which we have to support. They not only mean more maintenance for developers, but also more upgrade cycles for the users.
9.0 has not been in any stable Debian or Ubuntu release, and 9.1 final will be released soon. So we recently updated the current Ubuntu development release for 11.10 (“oneiric”) to 9.1. In Debian, the migration from 8.4/9.0 to 9.1 is making good progress, and there is not much which is left until postgresql-9.0 can be removed.
Consequently, I also removed 9.0 from my PostgreSQL backports PPA, as there is nothing any more to backport it from. However, that mostly means that people will now set up installations with 9.1 instead of 9.0, and won’t magically make your already installed 9.0 packages go away. They will just be marked as obsolete in the postgresql-common debconf note.
If you want to build future 9.0 packages yourself, you can do this based on the current branch: bzr branch lp:~pitti/postgresql/debian-9.0, get a the new upstream tarball, name it accordingly, add a new changelog with a new upstream version number, and run bzr bd to build the package (you need to install the bzr-builddeb package for this).
Update 2011-09-09: As I got a ton of pleas to continue the 9.0 backports for a couple of months, and to keep it in Debian unstable for a while longer, I put them back now. I also updated the removal request in Debian to point out that I’m mainly interested in getting 9.0 out of testing. I don’t mind much maintaining it for a couple of more months in unstable. My dear, I had no idea that my backports PPA was that popular!
#1 by Andres Freund on 2011/09/08 - 18:44
Zitieren
Hi,
Thats rather sad/annoying. For one nobody will use 9.1 in production for at least half a year, for another there are multiple sites using your pg 9.0 backports in production. Many of those won’t really notice that the support ended in time. So either they will soon run outdated versions…
The worst case is that some machine dies, they reinstall and try to start from the (hot-)backuped data dir….
Don’t get me wrong – I am very thankful for all your work in that area!
Andres
#2 by Luca Falavigna on 2011/09/08 - 21:52
Zitieren
There’s a typo in the URL for bug #639465, you should remove “bugs/”.
#3 by Joshua on 2011/09/08 - 22:00
Zitieren
Will you discontinue your PPA when apt.postgresql.org fully comes on line?See http://tapoueh.org/blog/2011/09/05-apt-postgresql-org.html for more info.
#4 by pitti on 2011/09/09 - 06:32
Zitieren
Thanks, Debian bug URL fixed.
#5 by pitti on 2011/09/09 - 06:34
Zitieren
Yeah, when apt.p.o gets working, it seems appropriate to not have packages in several places.
#6 by pitti on 2011/09/09 - 06:35
Zitieren
As for the notification, you should get a debconf message during upgrade which points out that 9.0 is not supported any more.
#7 by pitti on 2011/09/09 - 06:36
Zitieren
However, as there have been a lot of requests for keeping 9.0 a little longer, I’ll probably put them back into the PPA, for as long as they stay around in Debian unstable. My main concern is to get them out of Ubuntu and Debian testing, but I don’t mind having them around in Debian unstable only for some more time.
#8 by Tomasz Rybak on 2011/09/09 - 10:46
Zitieren
What about PostGIS? The only PostgreSQL version that is currently supported in Debian is 8.4, and this prevents me from removing 8.4 from my machine. Yes, I know that 8.4 is in stable so it will be maintained for the long time, but I also would like to have as little as possible PostgreSQL versions on my machines
#9 by Andy Allan on 2011/09/09 - 12:16
Zitieren
Thanks for putting them back in! In my case, the problem was that postgres isn’t the “end product” as such. I’ve no objections to 9.1 itself, but when there’s no postgres-9.1-postis package from anywhere my hands are tied. And given that postgis 2.0 is nearly out, I’d hate to discover that the postgis package is also a beta/RC for 2.0, which might not work with the apps I have…. Depedency nightmare!
It would be nice to have the 9.0 packages around for long enough to give everyone the opportunity to create and test updated dependencies. Thanks again for re-instating them.
#10 by Josh Berkus on 2011/09/09 - 18:31
Zitieren
Martin,
Your PPAs are the primary way people install PostgreSQL on Ubuntu, I think. You should get some download stats, I’d bet they’d be interesting.
Pingback: Martin Pitt: PostgreSQL 9.1 final packages available for Debian/Ubuntu | Ubuntu Forms
#11 by Rayudu on 2012/06/16 - 10:24
Zitieren
Sir,
Kindly point me to the repositories of Postgres 9.0.5 for ubunu 11.10 oneiric amd-64. I need the contrib specifically the dblink. I am already in production with 9.0.5.
regards,
rayudu
#12 by pitti on 2012/06/19 - 06:56
Zitieren
PostgreSQL 9.0 has never been packaged/supported by Ubuntu, I’m afraid. There is a packaging branch, so if you desperately need it, you can create packages yourself without too much effort, though.