无法在Ubuntu 15.04上安装postgresql 9.6

Question

要在Ubuntu15.04上安装PostgreSQL9.6，我遵循了这里和这里中的步骤

安装时我会收到这个错误。

Preparing to unpack .../postgresql-contrib_9.6+180.pgdg16.04+1_all.deb ...
Unpacking postgresql-contrib (9.6+180.pgdg16.04+1) ...
Setting up postgresql-9.6 (9.6.2-1.pgdg16.04+1) ...
Can't locate PgCommon.pm in @INC (you may need to install the PgCommon 
module) (@INC contains: /usr/share/postgresql-common 
/usr/local/lib/perl5/site_perl/5.24.1/x86_64-linux 
/usr/local/lib/perl5/site_perl/5.24.1 
/usr/local/lib/perl5/5.24.1/x86_64-linux /usr/local/lib/perl5/5.24.1 .).
BEGIN failed--compilation aborted.
dpkg: error processing package postgresql-9.6 (--configure):
subprocess installed post-installation script returned error exit status 2
dpkg: dependency problems prevent configuration of postgresql-contrib-9.6:
postgresql-contrib-9.6 depends on postgresql-9.6 (= 9.6.2-1.pgdg16.04+1); however:
Package postgresql-9.6 is not configured yet.

它是说找不到PgCommon.pm。我对perl模块不太熟悉。所以我试着安装PgCommon，但没有成功。

cpan
cpan >> install PgCommon

请帮我把它安装好。谢谢

sudo apt-cache madison postgresql | grep -vi sources输出

postgresql | 9.6+180.pgdg16.04+1 | http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg/main amd64 Packages
postgresql | 9.4+166bzr2 | http://in.archive.ubuntu.com/ubuntu/ vivid/main amd64 Packages

Answer 1

我已经用我的机器解决了这个问题。此错误阻碍了安装：

Can't locate PgCommon.pm in @INC (you may need to install the PgCommon 
module) (@INC contains: /usr/share/postgresql-common 
/usr/local/lib/perl5/site_perl/5.24.1/x86_64-linux 
/usr/local/lib/perl5/site_perl/5.24.1 
/usr/local/lib/perl5/5.24.1/x86_64-linux /usr/local/lib/perl5/5.24.1 .)

我发现，由于perl依赖关系，它无法安装。所以我确实按照命令跑了。

which perl
>>>> /usr/local/lib/perl

在googling搜索之后，我发现对于成功的postgres安装，实际路径应该是/usr/bin/perl。Perl在我的系统上安装了不止一次。这就是问题所在。所以我删除了目录：

sudo rm -rf /usr/local/lib/perl
sudo rm -rf /usr/local/bin/perl

之后，我运行以下命令成功安装postgres。

sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | 
sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

Answer 2

已经卡在postgresql 9.6: libpq5 (>= 9.6.10)上，但是9.5.14-0ubuntu0.16.04将被安装几天。

尝试了几种解决方案，如上面的解决方案，但最终总是出现上述错误。终于解决了

sudo aptitude install libpq5=11.0-1.pgdg16.04+2
sudo apt install -f postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6