MIgrating Qlik Sense to a another server

QueenS — Mon, 12 May 2025 07:00:22 GMT

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?

Re: MIgrating Qlik Sense to a another server

henrikalmen — Mon, 12 May 2025 12:49:02 GMT

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-Sense-PostgreSQL/ta-p/1820358 and possibly the link on that page that leads to https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238

topic Re: MIgrating Qlik Sense to a another server in Management & Governance

MIgrating Qlik Sense to a another server

Re: MIgrating Qlik Sense to a another server