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

2018-03-21 14:02 GMT+01:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> 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.

I have followed more than once the exact directions from the download page:

https://www.postgresql.org/download/linux/ubuntu/

Just pretend you are running 17.10 instead of 17.04.

It simply works.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS