在Linux Mint 17.3 (rosa)中安装最新Postgres (11.1)失败

Question

我在Linux Mint 17.3环境中安装postresql-11时遇到问题：

clutax@clutax:/home/clutax > sudo lsb_release -a
[sudo] password for clutax: 
No LSB modules are available.
Distributor ID: LinuxMint
Description:    Linux Mint 17.3 Rosa
Release:        17.3
Codename:       rosa


clutax@clutax:/home/clutax > sudo aptitude install postgresql-11
    The following NEW packages will be installed:
      libpq5{ab} postgresql-11{b} postgresql-client-11{a} 
    The following packages are RECOMMENDED but will NOT be installed:
      sysstat 
    0 packages upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
    Need to get 15,4 MB of archives. After unpacking 51,8 MB will be used.
    The following packages have unmet dependencies:
     postgresql-11 : Depends: libicu55 (>= 55.1-1~) which is a virtual package.
                     Depends: libllvm6.0 (>= 1:6.0~svn298832-1~) which is a virtual package.
                     Depends: libssl1.0.0 (>= 1.0.2~beta3) but 1.0.1f-1ubuntu2.27 is installed.
                     Depends: libstdc++6 (>= 5.2) but 4.8.4-2ubuntu1~14.04.4 is installed.
                     Depends: libsystemd0 which is a virtual package.
     libpq5 : Depends: libssl1.0.0 (>= 1.0.2~beta3) but 1.0.1f-1ubuntu2.27 is installed.
    The following actions will resolve these dependencies:

         Keep the following packages at their current version:
    1)     libpq5 [Not Installed]                             
    2)     postgresql-11 [Not Installed]                      
    3)     postgresql-client-11 [Not Installed]               


    Accept this solution? [Y/n/q/?] Y
    No packages will be installed, upgraded, or removed.
    0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    Need to get 0 B of archives. After unpacking 0 B will be used.

    clutax@clutax:/home/clutax > ^C

我该如何解决这些问题？

Answer 1

检查你的linux-mint的apt存储库，看看它是仿生的、Xenial的还是可信的，并添加正确的repo。否则，您将继续收到此错误。

例如：仿生：

$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" > \ 
/etc/apt/sources.list.d/postgresql.list'

Xenial：

    $ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main" > \ 
/etc/apt/sources.list.d/postgresql.list'

然后添加包存储库密钥：

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

并继续更新和安装过程的其余部分。