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

On 03/20/2018 05:34 PM, Adrian Klaver wrote:
> On 03/20/2018 02:25 PM, Stuart McGraw wrote:
>> On 03/20/2018 02:19 PM, Christoph Berg wrote:
>>  > Re: Adrian Klaver 2018-03-20 <4c40e7c5-efa7-00d7-b891-acc9c1ec75b0@aklaver.com>
>>  >>> However I need to upgrade to 10.3 and the normal "apt update;
>>  >>> apt upgrade" does not offer 10.3.  Also, doing a fresh install
>>  >>> still installs 10.1.
 >> [...]
>> Thank you Christoph and Adrian.
>> I changed the apt source to
>>    deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
>>
>> Then (transcripts edited for brevity)...
>>    # apt-get dist-update
> 
> I am going  to say that was apt-get update. More below.
> 
>>    ...
>>    # apt-get dist-upgrade
>>    The following packages will be REMOVED:
>>      pgadmin3
>>    The following packages will be upgraded:
>>      pgadmin3-data postgresql postgresql-client postgresql-client-common
>>      postgresql-common postgresql-contrib postgresql-doc postgresql-doc-10
>>      postgresql-server-dev-10
>>    9 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
>>
>> after completing the update and rebooting:
>>
>>    $ psql --version
>>    psql (PostgreSQL) 10.1
>>    $ psql -c 'select version()'
>>    PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 6.3.0-12ubuntu2) 6.3.0 20170406, 64-bit
> 
> I suspect the above is coming from the Ubuntu repo, not the PGDG one.

I had also tried 'apt-get upgrade' but that looked less promising
   # apt-get upgrade
   The following packages have been kept back:
     libdbd-pg-perl libpq-dev libpq5 pgadmin3 pgadmin3-data postgresql-10
     postgresql-client-10
   The following packages will be upgraded:
     postgresql postgresql-client postgresql-client-common postgresql-common
     postgresql-contrib postgresql-doc postgresql-doc-10 postgresql-server-dev-10
   8 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
The results turned out the same: postgresql-10.1, not 10.3.

I took this to suggest using dist-upgrade:

   https://wiki.postgresql.org/wiki/Apt/FAQ#How_do_I_dist-upgrade.3F

and that it should "just work".

> As an example from an Ubuntu machine that is using the PGDG repo:
> 
> psql --version
> psql (PostgreSQL) 10.3 (Ubuntu 10.3-1.pgdg16.04+1)
> postgres=# select version();
>   PostgreSQL 10.3 (Ubuntu 10.3-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9)
5.4.020160609, 64-bit
 
> 
>> Likely I am missing something obvious due to my newness with Ubuntu,
>> but isn't the above supposed to work?  10.3 is a minor upgrade, yes?
> 
> Yes it is a minor upgrade.
> 
> What does pg_lsclusters show?

# pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5432 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log