The first Beta of the upcoming PostgreSQL 9.2 was released yesterday (see announcement). Your humble maintainer has now created packages for you to test. Please give them a whirl, and report any problems/regressions that you may see to the PostgreSQL developers, so that we can have a rock solid 9.2 release.
Remember, with the postgresql-common infrastructure you can use pg_upgradecluster to create a 9.2 cluster from your existing 8.4/9.1 cluster and run them both in parallel without endangering your data.
For Debian the package is currently waiting in the NEW queue, I expect them to go into experimental in a day or two. For Ubuntu 12.04 LTS you can get packages from my usual PostgreSQL backports PPA. Note that you need at least postgresql-common version 0.130, which is available in Debian unstable and the PPA now.
I (or rather, the postgresql-common test suite) found one regression: Upgrades do not keep the current value of sequences, but reset them to their default value. I reported this upstream and will provide updated packages as soon as this is fixed.
Pingback: Martin Pitt: Debian/Ubuntu Packages for PostgreSQL 9.2 Beta 1 | Linux-Support.com
Pingback: Ubuntu developers: Martin Pitt: Debian/Ubuntu Packages for PostgreSQL 9.2 Beta 1 | Linux-Support.com
#1 by Andrew Francis on 2012/05/16 - 13:16
Zitieren
Thanks for packaging this up!
My lucid (10.04 LTS) system wants to upgrade libpq5 and libpq-dev from 9.1.3-1~lucid to 9.2~beta1-1~lucid1, while keeping postgresql, postgresql-client-common, postgresql-common and postgresql-contrib on 9.1.
What’s the best way to avoid this?
#2 by pitti on 2012/05/16 - 14:41
Zitieren
If you insist, you can use apt pinning (man apt_preferences) to keep those at 9.1. However, it’s not really a problem to use libpq from PostgreSQL 9.2, it’s fully backwards compatible. I checked 8.4, 9.1, and 9.2 against libpq 9.2 in the postgresql-common test suite.
#3 by dincer salih kurnaz on 2012/05/17 - 15:29
Zitieren
Good news immediately trying
#4 by Nick on 2012/05/20 - 12:16
Zitieren
Thanks for working on the packaging.
They don’t seem to be in experimental yet, or am I doing it wrong?
#5 by pitti on 2012/05/20 - 15:18
Zitieren
Right, they are still in the NEW queue.
Pingback: Ubuntu Weekly Newsletter Issue 266 | Ubuntu Linux FAQs
#6 by Steinar H. Gunderson on 2012/05/22 - 11:36
Zitieren
postgresql-common rocks
#7 by Hannu Valtonen on 2012/05/23 - 20:44
Zitieren
Any plans on adding support for pg_upgrade in package upgrades?
#8 by pitti on 2012/05/24 - 07:00
Zitieren
pg_upgrade support would certainly be nice, but requires some prerequisite work to make pg_upgrade work with config files in /etc/ and data files elsewhere. Unfortunately I haven’t found time to do this so far, so any help appreciated.
#9 by Nick on 2012/05/26 - 17:32
Zitieren
I’ve installed from experimental now – thanks!
#10 by Stuart Bishop on 2012/06/01 - 14:49
Zitieren
We have upgraded several servers now from 8.4 -> 9.1 using pg_upgrade – the only trick seems to be create a symlink to /etc/postgresql/$ver/$cn/postgresql.conf in the $datadir. I was hoping conf file location would have been added into 9.2.
#11 by Roger Hunwicks on 2012/06/13 - 13:01
Zitieren
Is there any way that the pldebugger contrib module can be packaged for Ubuntu?
It was the edg-debugger on pgfoundry, but it now seems to have moved to http://git.postgresql.org/gitweb/?p=pldebugger.git
I think it is included with the Windows installer, and maybe with the EnterpriseDb and OpenSCG Linux packages, but I can’t see an easy way to get it for an Ubuntu-packaged installation.
I want to use it in development, but our production servers are using the Ubuntu-packaged postgresql and won’t be changed.
Thanks in anticipation.
#12 by pitti on 2012/06/19 - 06:57
Zitieren
@Roger: I suggest to maill to http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public where packaging of extensions is being coordinated.