无法在Ubuntu上升级PostgreSQL

Question

当我运行apt-get upgrade时，会得到以下错误：

dpkg: dependency problems prevent configuration of postgresql-9.1:
 postgresql-client-9.1 (9.1.7-0ubuntu12.04) breaks postgresql-9.1 (<< 9.1.7-0ubuntu12.04) and is installed.
  Version of postgresql-9.1 to be configured is 9.1.6-1~precise2.
dpkg: error processing postgresql-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
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          No apport report written because the error message indicates its a followup error from a previous failure.
                               No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                                                         No apport report written because MaxReports is reached already
                  dpkg: dependency problems prevent configuration of postgresql-contrib-9.1:
 postgresql-contrib-9.1 depends on postgresql-9.1 (= 9.1.7-0ubuntu12.04); however:
  Version of postgresql-9.1 on system is 9.1.6-1~precise2.
dpkg: error processing postgresql-contrib-9.1 (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib:
 postgresql-contrib depends on postgresql-contrib-9.1; however:
  Package postgresql-contrib-9.1 is not configured yet.
dpkg: error processing postgresql-contrib (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postgresql-9.1
 postgresql
 postgresql-contrib-9.1
 postgresql-contrib
E: Sub-process /usr/bin/dpkg returned an error code (1)

我尝试了apt-get -f upgrade，但同样的错误也发生了。

我能做些什么来解决这个问题？完全搞砸了。

注意:对于PostgreSQL，我使用了以下PPA：https://launchpad.net/~pitti/+archive/postgresql

更新:不好意思格式化，下面是一个gist https://gist.github.com/e0752bb50e63ef4b3a4c

Answer 1

我也有同样的问题。apt-get -f install不管用。很有天赋就成功了。

aptitude -f install删除了postgres，但没有删除数据库。然后，apt-get install postgres重新安装postgres。再次高兴:-)

Answer 2

不久前在一台测试机器上也有同样的问题。

我刚刚禁用皮蒂，卸载，清洗，重新安装，启用皮蒂，更新。也许我错过了一些步骤，但对我来说，这是有帮助的。

相关的历史线索：

sudo vim /etc/apt/sources.list.d/ubuntugis-ppa-precise.list
sudo vim /etc/apt/sources.list.d/pitti-postgresql-precise.list
sudo apt-get remove postgresql-9.1
sudo apt-get remove postgresql-client-9.1
sudo apt-get clean
sudo apt-get update
sudo apt-get install postgresql-9.1
sudo apt-get install postgresql-9.1-postgis 
sudo apt-get install postgresql-contrib-9.1 
sudo vim /etc/apt/sources.list.d/pitti-postgresql-precise.list
sudo vim /etc/apt/sources.list.d/ubuntugis-ppa-precise.list 
sudo apt-get update
sudo apt-get upgrade