Two weeks ago, PostgreSQL announced the first beta version of the new major 9.1 version, with a lot of anticipated new features like synchronous replication or better support for multilingual databases. Please see the release announcement for details.
Due to my recent moving and the Ubuntu Developer Summit it took me a bit to package them for Debian and Ubuntu, but here they are at last. I uploaded postgresql-9.1 to Debian experimental; currently they are sitting in the NEW queue, but I’m sure our restless Debian archive admins will get to it in a few days. I also provided builds for Ubuntu 10.04 LTS, 10.10. and 11.04 in my PostgreSQL backports for stable Ubuntu releases PPA.
I provided full postgresql-common integration, i. e. you can use all the usual tools like pg_createcluster, pg_upgradecluster etc. to install 9.1 side by side with your 8.4/9.0 instances, attempt an upgrade of your existing instances to 9.1 without endangering the running clusters, etc. Fortunately this time there were no deprecated configuration options, so pg_upgradecluster does not actually have to touch your postgresql.conf for the 9.0 →9.1 upgrade.
They pass upstream’s and postgresql-common’s integration test suite, so should be reasonably working. But please let me know about everything that doesn’t, so that we can get them in perfect shape in time for the final release.
I anticipate that 9.1 will be the default (and only supported) version in the next Debian release (wheezy), and will most likely be the one shipped in the next Ubuntu LTS (in 12.04). It might be that the next Ubuntu release 11.10 will still ship with 9.0, but that pretty much depends on how many extensions get ported to 9.1 by feature freeze.
#1 by ilmari on 2011/05/11 - 14:31
Zitieren
“the next Ubuntu release 11.04″ – I assume you mean 11.10?
#2 by Colin 't Hart on 2011/05/11 - 15:06
Zitieren
Great! Let the testing begin!
And I think it should be Ubuntu 11.10 in the last sentence…
#3 by pitti on 2011/05/11 - 17:53
Zitieren
Indeed, thanks for pointing out. Fixed the article.
#4 by Sebastiaan Stok on 2011/05/11 - 19:35
Zitieren
I wonder, why is the Ubuntu package of PosgreSQL 9.0 (and above?) not using the new pg_upgrade and instead uses dump/restore (which can really take very long…)
#5 by gwc on 2011/05/11 - 21:31
Zitieren
Thanks for making these packages available! I’m in the process of testing 9.0.4 in my prototype production environment as I compose this message.
#6 by pitti on 2011/05/12 - 08:02
Zitieren
pg_upgrade is still fairly new, and there were still quite a lot of problems with it. It is also not quite sufficient by itself, for example it does not adapt library paths, rewrite obsolete configuration parameters, etc. I think at some point I’ll change pg_upgradecluster to use pg_upgrade, but I haven’t found time to do this yet.
Pingback: Packages for PostgreSQL 9.1 Beta 1 now available « Martin Pitt | Again?
#7 by Joe on 2011/05/13 - 14:43
Zitieren
I’m trying to build beta1 on wheezy but configure says it can’t find readline. For 9.0 you linked with libedit2. How can I do that if I want readline support?
#8 by pitti on 2011/05/16 - 09:45
Zitieren
Just install libreadline-dev and build it (add it to the Build-depends: if you use pbuilder). Note that postgresql-common’s wrapper already uses libreadline if available.
#9 by Shish on 2011/05/19 - 13:02
Zitieren
Thankyou for all the things you do
#10 by Nicklas Avén on 2011/05/19 - 15:53
Zitieren
Thanks a lot Martin
It is much more convenient to just install your packages than installing the one-click installer (or compiling).
Are you planning to package pgAdmin 1.14 beta1 too ?
/Nicklas
#11 by pitti on 2011/05/19 - 17:06
Zitieren
I am not using or maintaining the pgadmin package myself. If someone wants to package it, I’m happy to put it into the PPA, but I’m a bit hesitant to add beta versions here unless they use different package names. Some people actually use this PPA on production systems.
Pingback: Open Source Business Intelligence on the Cloud « DECISION STATS