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

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?

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.


> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com