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