Re: postgresql-10.3 on unbuntu-17.10 - how?? - Mailing list pgsql-general
From | Stuart McGraw |
---|---|
Subject | Re: postgresql-10.3 on unbuntu-17.10 - how?? |
Date | |
Msg-id | 484559c1-9dea-085c-4f55-fb22d246ef24@mtneva.com Whole thread Raw |
In response to | Re: postgresql-10.3 on unbuntu-17.10 - how?? (Adrian Klaver <adrian.klaver@aklaver.com>) |
List | pgsql-general |
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.
pgsql-general by date: