Mailinglist Archive: opensuse-support (80 mails)

< Previous Next >
Re: [opensuse-support] Leap 15.0 - Migrate to PostgreSQL 10
  • From: Maximilian Trummer <maximilian@xxxxxxxxxxx>
  • Date: Mon, 22 Oct 2018 14:46:01 +0200
  • Message-id: <3645694.llpd3kd91z@ryzen>
Am Sonntag, 21. Oktober 2018, 23:57:00 CEST schrieb Knurpht-openSUSE:
Op zondag 21 oktober 2018 23:07:04 CEST schreef Maximilian Trummer:
Hey, I have a machine that was upgraded from Leap 42.3 to Leap 15.0.
It still uses PostgreSQL 9.6 and starts it automatically in the systemd
service (postgresql.service).

How can I migrate this to use PostgreSQL 10? It's already installed but
I'm
not sure how to proceed. Do I also need to upgrade databases with
pg_upgrade?

regards

use
update-alternaves --config postgresql
It will show you 10 is the default configured, and let you set 96 as the
default.
Thanks, but I *want* to upgrade to Postgres 10, which is already configured
as the default (selected from "auto mode").

However, this still shows Postgres 9.6 being used:
$ ps aux | grep postgres

output:
/usr/lib/postgresql96/bin/postgres -D /var/lib/pgsql/data

So why is the old version still started, even though 10 is selected in update-
alternatives?

regards
< Previous Next >
Follow Ups