Hot on the heels of the PostgreSQL 9.1.0 release I am happy to announce that the final version is now packaged for Debian unstable, the current Ubuntu development version “Oneiric”, and also in my Ubuntu backports PPA for Ubuntu 10.04 LTS, 10.10, and 11.04.
Enjoy trying out all the cool new features like builtin synchronous replication or per-column collation settings for correctly handling international strings, or an even finer-grained access control for large environments. Please see the detailled explanation of the new features.
As already announced a few days ago, 9.0 is gone from Ubuntu 11.10, as it is still only a development version and not an LTS. 9.1 will be the version which the next 12.04 LTS will support, so this slightly reduces the number of major upgrades Ubuntu users will need to do. However, 9.0 will still be available in Debian unstable and backports, and the Ubuntu backports PPA for a couple of months to give DB administrators some time to migrate.
#1 by Toby Corkindale on 2011/09/13 - 07:40
Zitieren
Hi Martin,
Thankyou very much for your quick packaging.
I’ve been happily using the 9.1 RC and final on Ubuntu from your PPA, however I’d also like to deploy 9.1 on some Debian Squeeze systems, where we’re currently using your 9.0 build from squeeze-backports.
Are you intending on building 9.1 for squeeze-backports as well?
Cheers,
Toby
#2 by pitti on 2011/09/13 - 08:41
Zitieren
The policy for backports.org is that a package needs to go into testing before it gets backported, so it will still take about 10 days before that happens. But I already talked to Gerfried Fuchs (the backports.org maintainer), he will of course provide a -9.1 backport for squeeze.
#3 by Andres Freund on 2011/09/13 - 10:26
Zitieren
Thanks for providing the backports. Especially the longer support for the 9.0 one!
#4 by mkurz on 2011/09/13 - 11:28
Zitieren
Hi Martin!
Great work!
Could you also backport pgadmin3 v1.14 on your ppa?
On https://github.com/postgres/pgadmin3 there is already a tag for the 1.14 release, and it’s also available on http://www.postgresql.org/ftp/pgadmin3/release/v1.14.0/.
Thanks!
#5 by mirabilos on 2011/09/13 - 11:59
Zitieren
The m68k packages are now also uploaded
#6 by pitti on 2011/09/13 - 15:56
Zitieren
1.14 is in Debian unstable indeed. However, I have zero knowledge about pgadmin3, so I’d appreciate if someone could actually test whether 1.14 builds and works as expected in lucid/maverick/natty? Once that’s confirmed, I’m happy to upload backports.
#7 by Anthony on 2011/09/14 - 03:13
Zitieren
Please excuse a question from a somewhat recent Ubuntu user (running Natty): I have your repository added to my system: http://ppa.launchpad.net/pitti/postgresql/ubuntu
Because of that, would I automatically get the full 9.1 update? Today, in checking for updates, I saw some 9.1 header files but nothing to indicate a complete 9.1 upgrade.
Or must I perform a 9.1 upgrade manually?
Thanks for your help!
#8 by pitti on 2011/09/14 - 05:54
Zitieren
With the PPA configured, a standard upgrade should catch postgresql as well, yes. It still doesn’t work? Please check the output of “apt-cache policy postgresql-9.1″, it should show 9.1.0-1~natty1 for the PPA, _not_ 9.1.0~rc1-…
#9 by Anthony on 2011/09/16 - 03:20
Zitieren
Hi, sorry for the delayed response. I tested “apt-cache policy postgresql-9.1″, and it indeed does show 9.1.0-1~natty1 for the PPA.
So, not sure why I’m not automatically getting the 9.1 upgrade.
#10 by Anthony on 2011/09/16 - 03:44
Zitieren
Also, just to reiterate my original question: Would I expect my subscription to the PPA to automatically install 9.1? Would that overwrite 9.0 or install 9.1 side by side? I’m on the lookout for the best practices for moving from one version of Postgres to the next, including database and data migration.
Thank you in advance.
#11 by Adam on 2011/09/18 - 00:20
Zitieren
I’ve been using 9.0 from your PPA. how do I prevent apt-get dist-upgrade from automatically installing 9.1? I’ve looked at pinning etc, but I think that will prevent me from getting security fixes in 9.0 because it locks on a particular version?
#12 by pitti on 2011/09/18 - 11:31
Zitieren
9.1 is not installed automatically, you have to explicitly install “postgresql-9.1″. If you have 9.0 installed, it will only automatically upgrade to new -9.0 versions. 9.1 will get installed side by side, please see /usr/share/doc/postgresql-common/README.Debian.gz
#13 by pitti on 2011/09/18 - 11:31
Zitieren
It’s not automatically upgraded, please see my previous answer here.
#14 by wilk on 2011/09/18 - 14:53
Zitieren
For people who cannot wait for backport and want to use or test differents postgresql version than the one of their distro, i suggest to try in a virtual system, like LXC. Hope to help.
Thanks martin for you work !
#15 by Dan Delaney on 2011/10/05 - 16:42
Zitieren
Thanks so much for making this available so quickly!
Do you know if the PHP packages for PostgreSQL 9.1 will also be put into the backports?
#16 by pitti on 2011/10/06 - 07:17
Zitieren
Which package is that? We don’t have a PL/PHP package as far as I can see?
#17 by Dan Delaney on 2011/10/17 - 17:59
Zitieren
Sorry, I should have explained. I’m talking about the PHP modules that connect to PostgreSQL. The Ubuntu package name is “php5-pgsql”, which contains the old pgsql module and the new pdo_pgsql module, both of which need to be compiles using the header files found in a “postgresql-server-dev-” package. I’m assuming that in order for PHP to connect to a 9.1 server it will have to have those modules compiled with the header files for 9.1.
#18 by pitti on 2011/10/27 - 08:11
Zitieren
The client-side API did not change, so for connecting to PostgreSQL 9.1 from PHP the current module should work just fine.
#19 by Matija on 2011/11/25 - 14:02
Zitieren
While trying to install 9.1 for a Ubuntu Natty, I get a failure because the version in the ppa repository is 9.1.1-1, and the postgresql-common in the same repository says it breaks any posgresql-9.1 with version less than 9.1.1-3
#20 by pitti on 2011/11/25 - 16:22
Zitieren
Sorry, I also uploaded a newer postgresql-9.1 now which fixes that. Will take a bit to build, though.