PostgreSQL 9.2 has just been released, after a series of betas and a release candidate. See for yourself what’s new, and try it out!
Packages are available in Debian experimental as well as my PostgreSQL backports PPA for Ubuntu 10.04 to 12.10, as usual.
Please note that 9.2 will not land any more in the feature frozen Debian Wheezy and Ubuntu Quantal (12.10) releases, as none of the server-side extensions are packaged for 9.2 yet.
#1 by Roger Leigh on 2012/09/10 - 20:40
Zitieren
postgresql-debversion is already done–I packaged it as soon as -rc2 was uploaded to experimental; it’s now also in experimental and ready to go into unstable as soon as postgresql is uploaded there. It’s also on PGXN, for anyone not using Debian.
Regards,
Roger
#2 by mvp on 2012/09/12 - 22:39
Zitieren
I am looking for updated PostgreSQL 9.2 package for Ubuntu 11.04 (natty).
For whatever reason your PPA does not have PostgreSQL 9.2 built for natty (but it exists for 9,1).
Would you please consider making 9.2 package for natty as well?
Thank you very much!
#3 by pitti on 2012/09/13 - 09:07
Zitieren
Sure, no problem. I just didn’t consider Natty a very interesting server platform any more, but it’s uploaded now. Should be built in an hour or so.
#4 by mvp on 2012/09/13 - 09:41
Zitieren
Martin, you absolutely rock!
Thank you so much!
We use natty for 2 reasons:
- it is last Ubuntu version to still have Gnome2
- our IT does not support anything more recent, yet.
Again, thanks and bless you!
#5 by cc young on 2012/09/13 - 15:50
Zitieren
you say “none of the server-side extensions are packaged for 9.2 yet” – do you mean things like contrib or what? btw, many thanks for your work!
#6 by pitti on 2012/09/13 - 15:55
Zitieren
No, postgresql-contrib-9.2 is built by the postgresql-9.2 source. I mean third-party server side extensions like PostGIS, PL/R, PL/Java and the like. Also, “none” was a bit of an understatement, see Roger’s comment; but we just have one or two, whereas for -9.11 there are some 15.
#7 by HardDee on 2012/09/18 - 04:34
Zitieren
Hello Martin. I’ve been wanting to upgrade my Postgres 9.1.5 (Precise) to 9.2 using your PPA. I did add and apt-get postgres-9.2 all went well, however now I have 2 postgres and the main or current usable if I do psql –version is the 9.1.5. Can you spare me some ideas how can I remove my 9.1.5 and have this 9.2 only. I don’t want to have 2 postgres on my system, it’s confusing.
#8 by pitti on 2012/09/18 - 15:14
Zitieren
If you don’t need the data from your 9.1 cluster any more, or you already upgraded it (with pg_upgradecluster) to 9.2, you can just “sudo apt-get purge postgresql-client-9.1″. See /usr/share/doc/postgresql-common/README.Debian.gz for some details about the multi-version system.
#9 by James on 2012/09/18 - 17:59
Zitieren
Hi there Pitti. After adding your PPA, I did an update and upgrade, however when I’m about to `sudo apt-get install postgres-9.2` the system says “E: Unable to locate package postgres-9.2″, any insights? Thanks.
#10 by pitti on 2012/09/19 - 06:32
Zitieren
The package is called postgresql-9.2.
#11 by James on 2012/09/19 - 07:10
Zitieren
Sorry for that, late night syndrome, didn’t noticed that. Thanks for that! By the way, I’ve read that it is somewhat a release candidate, having it already in my PPA repository will that mean everytime you uploaded a new build for 9.2, just by doing apt-get update my version will already be updated? Is that right?
#12 by pitti on 2012/09/19 - 12:15
Zitieren
9.2 is not a release candidate, it’s the final version. But yes, if you enable my PPA, then apt-get dist-upgrade (not update) will automatically get you the latest point releases/bug fixes.
#13 by James on 2012/09/20 - 19:16
Zitieren
Hi again Martin. Thank you so much for the help. I finally got a hold of 9.2. However, I always see this error whenever I tried to create a database/table/schema via (phppgadmin & Navicat {SSH tunnel}) to my remote server “ERROR: column “spclocation” does not exist
LINE 1: …pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio…”.
#14 by pitti on 2012/09/20 - 21:15
Zitieren
I’m afraid I don’t know what queries spclocation, it’s not postgresql-common. It might be phpmyadmin itself?
#15 by James on 2012/09/21 - 01:23
Zitieren
Probably not. I just dig this mailing list, [http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php], kind of bug? Does this quite mean Postgres 9.2 has some issues with third party administration tools?
#16 by Patrik on 2012/09/25 - 18:59
Zitieren
Hi,
Trying to install 9.2 on debian squeeze 6.0.5. But it fails…
Added experimental to /etc/apt/sources.list and run:
apt-get -t experimental install postgresql-9.2
With the following result (sorry for the result in swedish, can I change it to another language, how?):
Läser paketlistor… Färdig
Bygger beroendeträd
Läser tillstÃ¥ndsinformation… Färdig
Några paket kunde inte installeras. Det kan betyda att du har begärt
en omöjlig situation eller, om du använder den instabila utgåvan
att några nödvändiga paket ännu inte har skapats eller flyttats
ut frÃ¥n “Incoming”.
Följande information kan vara till hjälp för att lösa situationen:
Följande paket har beroenden som inte kan tillfredsställas:
postgresql-9.2 : Beroende av: libssl1.0.0 (>= 1.0.0) men det kan inte installeras
Beroende av: postgresql-client-9.2 men det kommer inte att installeras
Beroende av: postgresql-common (>= 135~) men 130~bpo60+2 kommer att installeras
E: Trasiga paket
#17 by Patrik on 2012/09/25 - 19:03
Zitieren
Hmm, I’m a debian newbie, but in Englis it says:
root@www:~# apt-get -t experimental install postgresql-9.2
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.2 : Depends: libssl1.0.0 (>= 1.0.0) but it is not installable
Depends: postgresql-client-9.2 but it is not going to be installed
Depends: postgresql-common (>= 135~) but 130~bpo60+2 is to be installed
E: Broken packages
ro
#18 by pitti on 2012/09/26 - 06:03
Zitieren
Sorry, that doesn’t work. You can’t use experimental on Debian squeeze, that only works for Debian unstable (and testing usually). For Squeeze you need to run a proper backport. Until an official one is provided, use the one from http://pgapt.debian.net/ or build the source package yourself.
#19 by Patrik on 2012/09/26 - 16:09
Zitieren
Thank you for your answer!
Is there a guide somewhere (for a newbie like me), on how to install PostgreSQL from “http://pgapt.debian.net/ “?
Thanks in advance!
/Patrik
#20 by Patrik on 2012/09/27 - 14:58
Zitieren
Ok, this might be helpful for other debian newbies (I might have missed something below):
To install a recent version of PostgreSQL on “old” debian systems:
0) Find out which debian version you are running:
cat /etc/debian_version
1) Add the following to the bottom of the file: /etc/apt/sources.list
deb http://pgapt.debian.net/ squeeze-pgdg main (for debian 6.0)
or
deb http://pgapt.debian.net/ wheezy-pgdg main (for debian 6.0)
2) Download the gpg key:
wget http://pgapt.debian.net/ACCC4CF8.asc
3) Install the gpg key:
apt-key add ACCC4CF8.asc
4) Update:
apt-get update
5) Install PostgreSQL (example 9.2)
apt-get install postgresql-9.2
Thanks for your help!
/Patrik
#21 by Embi on 2012/10/05 - 15:16
Zitieren
This is a Postgresql 9.1 related question. I recently upgraded our Ubuntu server from 10.04LTS to 12.04LTS. I had Postgresql 9.1 installed already before the upgrade from your repository. Now I ran into the problem that I can not upgrade individual packages any more. I get the error message:
The following packages have unmet dependencies:
postgresql-client-9.1 : Breaks: postgresql-9.1 (< 9.1.6-0ubuntu12.04) but 9.1.5-1~lucid3 is installed
postgresql-contrib-9.1 : Depends: postgresql-9.1 (= 9.1.6-0ubuntu12.04) but 9.1.5-1~lucid3 is installed
E: Unmet dependencies. Try using -f.
Any ideas of how I can upgrade postgresql to the latest version 9.1.6 without a reinstallation?
#22 by pitti on 2012/10/06 - 19:15
Zitieren
This was an unfortunate versioning issue. If you still have my backports PPA enabled, you should be able to update and dist-upgrade now, I put 9.1.6 for 12.04 into the PPA a few days ago.
#23 by Embi on 2012/10/08 - 09:07
Zitieren
Unfortunately no luck yet, though I might miss something here. When I use apt-get update && apt-get upgrade, I still get dependency errors.
~$ sudo dpkg –configure -a
dpkg: dependency problems prevent configuration of postgresql-9.1:
postgresql-client-9.1 (9.1.6-1~precise2) breaks postgresql-9.1 (<< 9.1.6-1~precise2) and is installed.
Version of postgresql-9.1 to be configured is 9.1.5-1~lucid3.
dpkg: error processing postgresql-9.1 (–configure):
dependency problems – leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib-9.1:
postgresql-contrib-9.1 depends on postgresql-9.1 (= 9.1.6-0ubuntu12.04); however:
Version of postgresql-9.1 on system is 9.1.5-1~lucid3.
dpkg: error processing postgresql-contrib-9.1 (–configure):
dependency problems – leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-9.1; however:
Package postgresql-9.1 is not configured yet.
dpkg: error processing postgresql (–configure):
dependency problems – leaving unconfigured
Errors were encountered while processing:
postgresql-9.1
postgresql-contrib-9.1
postgresql
#24 by pitti on 2012/10/08 - 09:10
Zitieren
Try “sudo apt-get -f install”? and/or “dist-upgrade”?
#25 by Embi on 2012/10/08 - 09:22
Zitieren
No luck. I think I might have to remove the half-configured packages first, but I don’t know how.
poseidon@DEMETER:~$ sudo apt-get -f install
Reading package lists… Done
Building dependency tree
Reading state information… Done
Correcting dependencies… Done
The following extra packages will be installed:
postgresql-9.1 postgresql-contrib-9.1
Suggested packages:
oidentd ident-server locales-all libdbd-pg-perl
The following packages will be upgraded:
postgresql-9.1 postgresql-contrib-9.1
2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
3 not fully installed or removed.
Need to get 0 B/4,257 kB of archives.
After this operation, 599 kB disk space will be freed.
Do you want to continue [Y/n]? y
dpkg: dependency problems prevent configuration of postgresql-9.1:
postgresql-client-9.1 (9.1.6-1~precise2) breaks postgresql-9.1 (<< 9.1.6-1~precise2) and is installed.
Version of postgresql-9.1 to be configured is 9.1.5-1~lucid3.
dpkg: error processing postgresql-9.1 (–configure):
dependency problems – leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib-9.1:
postgresql-contrib-9.1 depends on postgresql-9.1 (= 9.1.6-0ubuntu12.04); however:
Version of postgresql-9.1 on system is 9.1.5-1~lucid3.
dpkg: error processing postgresql-contrib-9.1 (–configure):
dependency problems – leaving unconfigured
No apport report written because MaxReports is reached already
No apport report written because MaxReports is reached already
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-9.1; however:
Package postgresql-9.1 is not configured yet.
dpkg: error processing postgresql (–configure):
dependency problems – leaving unconfigured
No apport report written because MaxReports is reached already
Errors were encountered while processing:
postgresql-9.1
postgresql-contrib-9.1
postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)
#26 by Embi on 2012/10/08 - 12:56
Zitieren
Solution. I removed all the old packages with unmet dependencies using sudo dpkg –force-remove-reinstreq –remove {packages} and the reinstalled them all.
Thanks for your help.
#27 by Onk on 2012/10/18 - 01:27
Zitieren
I’m having trouble and posted it here:
http://stackoverflow.com/questions/12944830/error-upgrading-postgresql-cluster-from-9-1-to-9-2
pitti, where’s the best place to have these discussions? Here or SO or Launchpad?
Thanks,
Henri
#28 by pitti on 2012/10/18 - 05:37
Zitieren
There was an answer on SO already, but it would be nice if you could file a bug in Launchpad or Debian about this situation, so that it can be handled more gracefully. At least it should be covered by the test suite. We are going to switch to pg_upgrade soon, so keeping this under test coverage will ensure it’ll stay working once it gets fixed.
#29 by Anthony on 2012/11/12 - 06:36
Zitieren
Hello,
I’ve installed 9.2 Now, how can I specifically retrieve the pgadmin3 1.16.0 build from your PPA for my Ubuntu Quantal machine? I’ve added the PPA itself but apt-get keeps wanting to install 1.14.
Thanks …
#30 by pitti on 2012/11/13 - 07:54
Zitieren
I don’t have a pgadmin3 1.16 for Quantal, only for precise. I’m not using that myself, but if someone tests a 1.16 package on quantal and pokes me, I can put it in the PPA.
#31 by Anthony on 2012/11/15 - 04:13
Zitieren
I went ahead and built it from source. That was excrutiating, but I finally got there. Thanks.
#32 by Martyn on 2012/11/16 - 16:32
Zitieren
Is there a way to get pgadmin 3 1.16 on a debian wheezy system?
Thanks
#33 by pitti on 2012/11/19 - 06:52
Zitieren
You could ask pgadmin3@packages.debian.org about packaging the current version, then it can be backported.
#34 by Dmitrijs Ledkovs on 2012/11/27 - 16:01
Zitieren
Are you going to sync it from experimental into raring?
#35 by pitti on 2012/11/27 - 16:12
Zitieren
I’m a bit unsure; I wouldn’t want to support both 9.1 and 9.2 for raring, but as Debian is frozen we have no packaged extensions for 9.2. A lot of people use my backports PPA for getting the latest stuff for all supported releases, so the request doesn’t actually come up that much.
#36 by erick on 2012/12/02 - 06:13
Zitieren
Martin, is postgresql-contrib-9.2 including postgis2 extension?
#37 by pitti on 2012/12/02 - 10:34
Zitieren
No, postgis is a separate project, not part of the PostgreSQL releases.
#38 by snotling on 2012/12/15 - 10:22
Zitieren
There seems to be a tiny glitch with the postgresql-contrib-9.2 package: its description text is wrongly formatted in aptitude, as if some line returns were missing.
#39 by Lucia on 2012/12/24 - 16:56
Zitieren
Hello Martin,
I’m using Ubuntu 10.10, I followed these steps:
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
but Postgres 9 is still not available to install.
If I run this: sudo apt-get install postgresql-9.2, I get “Unable to locate package” error. Any idea why this happens?
#40 by Lucia on 2012/12/24 - 17:55
Zitieren
Ok, I just realized there is no backport for 10.10, the one for 10.04 should work, right?
#41 by pitti on 2012/12/25 - 22:44
Zitieren
That’s right, Ubuntu 10.10 went out of support 8 months ago.
#42 by Maik on 2013/02/05 - 15:28
Zitieren
Encountered the following problem when postgresql-client-9.1 updated:
sudo apt-get upgrade
Reading package lists… Done
Building dependency tree
Reading state information… Done
You might want to run ‘apt-get -f install’ to correct these.
The following packages have unmet dependencies:
postgresql-client-9.1 : Breaks: postgresql-9.1 (< 9.1.7-0ubuntu12.04) but 9.1.6-1~precise2 is installed
E: Unmet dependencies. Try using -f.
Is there an easy way to fix this. Upgrade to postgresql-9.2 also did not succeed.
Thanks.
#43 by pitti on 2013/02/11 - 08:16
Zitieren
Maik, try “sudo apt-get -f install” as suggested. There’s too little information in your comment to say what’s going on and why postgresql-9.1 wouldn’t be upgraded along with -client.