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.
