Hot on the heels of the Announcement of the second 9.1 Beta release there are now packages for it in Debian experimental and backports for Ubuntu 10.04 LTS, 10.10. and 11.04 in my PostgreSQL backports for stable Ubuntu releases PPA.
Warning for upgrades from Beta 1: The on-disk database format changed since Beta-1. So if you already have the beta-1 packages installed, you need to pg_dumpall your 9.1 clusters (if you still need them), and pg_dropcluster all 9.1 clusters before the upgrade. I added a check to the pre-install script to make the postgresql-9.1 package fail early to upgrade if you still have existing 9.1 clusters to avoid data loss.
#1 by Adrian on 2011/06/14 - 11:33
Zitieren
Hi Martin,
Thanks for your packages – any idea why 9.1 does not build on Ubuntu 10.04 amd64? It seems to fail every time.
#2 by pitti on 2011/06/14 - 12:19
Zitieren
It actually does build on i386, but for some reason debhelper on lucid behaves differently in -B mode (which is what amd64 uses). I haven’t had time to investigate this yet.
#3 by thomas on 2011/06/14 - 18:33
Zitieren
could you provide a hint on how to install these packages? i always get unmet dependencies in debian squeeze (with experimental source added):
root@server:/etc/apache2# apt-get install -t experimental postgresql-common
Reading package lists… Done
Building dependency tree
Reading state information… Done
postgresql-common is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 41 not upgraded.
root@server:/etc/apache2#
root@server:/etc/apache2# apt-get install -t experimental postgresql-9.1 postgresql-client-9. 1 postgresql-contrib-9.1
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
postgresql-9.1 : Depends: libpq5 (>= 9.1~beta1) but 9.0.4-1~bpo60+1 is to be installed
Depends: libssl1.0.0 (>= 1.0.0) but it is not installable
Depends: postgresql-common (>= 115~) but 114~bpo60+1 is to be installed
postgresql-client-9.1 : Depends: libssl1.0.0 (>= 1.0.0) but it is not installable
Depends: postgresql-client-common (>= 115~) but 114~bpo60+1 is to be i nstalled
postgresql-contrib-9.1 : Depends: libssl1.0.0 (>= 1.0.0) but it is not installable
Depends: postgresql-common (>= 115~) but 114~bpo60+1 is to be install ed
E: Broken packages
#4 by pitti on 2011/06/16 - 07:41
Zitieren
@thomas: I’m afraid this won’t work, as the 9.1 packages from experimental are built against the Debian unstable libraries. I suggest you either build the source yourself (apt-get source -b postgresql-9.1) or wait until 9.1 final is released, at which point it will go into unstable and squeeze-backports.
#5 by Piet on 2011/06/17 - 02:31
Zitieren
Is there a 9.1 compatible pgAdmin III yet?
#6 by pitti on 2011/06/17 - 07:06
Zitieren
Gerfried Fuchs has a PPA with the latest pgadmin3: https://launchpad.net/~rhonda/+archive/pgadmin3
#7 by simon on 2011/08/26 - 14:30
Zitieren
@pitti – any plans to release packages for RC1? pretty please?
#8 by pitti on 2011/08/26 - 16:36
Zitieren
Yep, I landed them in Debian unstable this week, and in Ubuntu Oneiric yesterday. Just now I uploaded backports to the postgresql PPA. Enjoy!