Re: postgresql-10.3 on unbuntu-17.10 - how?? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: postgresql-10.3 on unbuntu-17.10 - how??
Date
Msg-id d71e1f44-e5af-d0b5-68ee-785e294d069a@aklaver.com
Whole thread Raw
In response to Re: postgresql-10.3 on unbuntu-17.10 - how??  (Stuart McGraw <smcg4191@mtneva.com>)
Responses Re: postgresql-10.3 on unbuntu-17.10 - how??  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Re: postgresql-10.3 on unbuntu-17.10 - how??  (Stuart McGraw <smcg4191@mtneva.com>)
List pgsql-general
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 Pgdg 10.3 even available for ubuntu 17.10?  How the heck does
>>> one upgrade to it?
>>
>> 18.04 LTS (Bionic Beaver)?:
>>
>> http://apt.postgresql.org/pub/repos/apt/dists/bionic-pgdg/
> 
> I tried doing a full reinstall of Ubuntu-17.10 followed by a postgresql
> install from the bionic repo (instead of installing 10.1 per above and
> trying to upgrade)
> 
>    # apt-get -qy install postgresql postgresql-client postgresql-contrib \
>        postgresql-doc pgadmin3 postgresql-server-dev-10 libpq-dev
>    Reading package lists...
>    Building dependency tree...
>    Reading state information...
>     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:
>     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
>     postgresql : Depends: postgresql-10 but it is not going to be installed
>     postgresql-client : Depends: postgresql-client-10
>     postgresql-contrib : Depends: postgresql-contrib-10
>    E: Unable to correct problems, you have held broken packages.

If it where me I would simplify the above for the moment to :

apt-get install postgresql-10

> 
> 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.


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Is there a way to get the name of the calling function in pgplsql?
Next
From: Adrian Klaver
Date:
Subject: Re: Restore - disable triggers - when they fired?