Re: postgresql-10.3 on unbuntu-17.10 - how??

On 03/21/2018 07:02 AM, Adrian Klaver wrote:
> On 03/20/2018 10:52 PM, Stuart McGraw wrote:
> Looks like these posts are coming through a news group to me.
> I am Ccing list to get response back there.

Is this something I am doing wrong?  I am posting through the gmane newsgroup
which in turn is bi-directionally gatewayed to the list AIUI.

 >>[...]
>>    # apt-get -qy install postgresql postgresql-client postgresql-contrib \
>>        postgresql-doc pgadmin3 postgresql-server-dev-10 libpq-dev
>[...]
>>    The following packages have unmet dependencies:
>>     libpq-dev : Depends: libpq5 (= 10.3-1.pgdg18.04+1) but it is not going to be installed
>>     pgadmin3 : Depends: libgcrypt20 (>= 1.8.0) but 1.7.8-2ubuntu1 is to be installed
>>                Depends: libpq5 (>= 8.4~) but it is not going to be installed
>>                Recommends: pgagent but it is not going to be installed
>>[...]
> 
> If it where me I would simplify the above for the moment to :
> 
> apt-get install postgresql-10

Tried on a fresh Ubuntu-17.10 install (with no postgresql at all installed)
but similar problem persists with the postgresql from the pgdg bionic repo:

   # apt-get install postgresql-10
   ...
   The following packages have unmet dependencies:
    postgresql-10 : Depends: postgresql-client-10
                    Depends: libicu60 (>= 60.1-1~) but it is not installable
                    Depends: libpq5 (>= 9.3~) but it is not going to be installed
                    Depends: libssl1.1 (>= 1.1.0) but it is not installable
                    Recommends: sysstat but it is not going to be installed
   E: Unable to correct problems, you have held broken packages.

>> Is there any reason now not to conclude that the 10.3 bionic version is
>> simply incompatible with Ubuntu-17.10 (at least without a lot more package
>> wrangling chops than I have)?
>>
>> One can install postgresql-10.1 but one cannot upgrade it to get security
>> fixes or to be able to load data dumped from another 10.3 database.
>>
>> Given that Ubuntu-18.04 will be out soon I guess this is pretty much moot
>> except for a few unfortunates like me who absolutely need 10.3 but have no
>> option to upgrade.  I guess the lesson is that running the Pgdg versions
>> of Postgresql on any but the LTS versions of Ubuntu is pretty risky.
>> Live and learn.  Maybe this will help someone else.