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

On 03/20/2018 10:07 PM, Adrian Klaver wrote:
> On 03/20/2018 06:27 PM, Stuart McGraw wrote:
>> On 03/20/2018 06:42 PM, Stuart McGraw wrote:
>>> 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:
>>> [...]
>>>>>    # 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.
>>> [...]
>>>>> 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
>>
>> An additional bit of information.  Picking one of the installed packages
>> to look at:
>>
>> ~# apt-cache  policy postgresql-client
>> postgresql-client:
>>    Installed: 10+190.pgdg18.04+1
>>    Candidate: 10+190.pgdg18.04+1
>>    Version table:
>>   *** 10+190.pgdg18.04+1 500
>>          500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 Packages
>>          500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main i386 Packages
>>          100 /var/lib/dpkg/status
>>       9.6+184ubuntu1.1 500
>>          500 cdrom://Ubuntu-Server 17.10 _Artful Aardvark_ - Release amd64 (20180108.1) artful/main amd64 Packages
>>          500 http://us.archive.ubuntu.com/ubuntu artful-security/main amd64 Packages
>>          500 http://us.archive.ubuntu.com/ubuntu artful-security/main i386 Packages
>>          500 http://us.archive.ubuntu.com/ubuntu artful-updates/main amd64 Packages
>>          500 http://us.archive.ubuntu.com/ubuntu artful-updates/main i386 Packages
>>       9.6+184ubuntu1 500
>>          500 http://us.archive.ubuntu.com/ubuntu artful/main amd64 Packages
>>          500 http://us.archive.ubuntu.com/ubuntu artful/main i386 Packages
>>
>> I *think* the above is saying that the package was (or should be?) installed
>> from the pgdg repository.  So why isn't is getting the 10.3 versions?
>> (Thanks for the help so far!)
>
> I think it is installed.
>
> What does pg_lsclusters show?

I included it above but here it is again:
>>> # 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

> What does ps ax | grep postgres show?
> At this point do you have a running instance of Postgres and is it in use?
> If so I would take a pg_dump for safety's sake, before going any further.

Not functional at the moment, I was experimenting with trying to
remove and reinstall various packages. But I am doing this on a VM,
not my development machine where the real database to be upgraded
is.

Whether it was fully functional after the upgrade I can't say for sure
but the server restarted ok with no unusual messages and I could connect
to it with pgsql. But both continued to report their versions as 10.1.

After removing the main postgresql packages and reinstalling I got
some version conflicts which led to my to trying doing a clean install
of Ubuntu-17.10 followed by an install of postgresql-10 from the pgdg
bionic (rather than zesty) repo. It failed as described in a separate
post.