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

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(dot)klaver(at)aklaver(dot)com