MIgrating Qlik Sense to a another server

[QueenS]

Hi

I have Qlik Sense version Feb 2022 P1 installed on my server.

The postgress DB is 9.6.

I need to migrate it to another server, and I do the steps described in Qilk migration documentation.

When I install the same version in the new server, it installs progress db version 12.5 ,

and when I do pg_restore I get lots of errors like the following:

pg_restore: from TOC entry 11; 2615 698584 SCHEMA app_distribution_service qliksenserepository
pg_restore: error: could not execute query: ERROR: schema "app_distribution_service" already exists

I performed the dropdb & createdb as suggested, but still getting errors.

I suspect it might be the fact that I try to restore 9.6 db to 12.5 db. 

but as I mentioned, when I install new Qlik Sense with version Feb 2020 it installs the 12.5 db.

Please consult. 

Do I get these error because of the db versios are not compatible?

how can installed Qlik Sense with 9.6 db version?

[henrikalmen · Accepted solution]

I don't think you can. You should probably update postgres in your current environment, and after that perform the migration.

See https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sen... and possibly the link on that page that leads to https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...