topic Restore the QMC setting from the existing server to new server. in Management & Governance

Restore the QMC setting from the existing server to new server.

sten_still — Tue, 15 Aug 2023 06:20:23 GMT

Dear Techies,

Currently I'm moving the environment from the existing server to the new server due to upgrade and also changing from on-prem to VMs.

I have followed the steps from here : (https://help.qlik.com/en-US/sense-admin/May2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm )

However I am getting the error of pg_restore: warning: errors ignored on restore: 22 when restoring the backup QSR.

Any advice are welcome and appreciated.

Thanks,

Amir

Re: Restore the QMC setting from the existing server to new server.

Albert_Candelario — Tue, 15 Aug 2023 13:46:39 GMT

Hello @sten_still,

Thanks for posting.

This is a warning, is the restore indeed failing or not? If is not failing could be ignored.

Also remember to use the same version during the backup and the restore and afterward you can upgrade to a newer version.

Let us know!

Cheers,

Albert

Re: Restore the QMC setting from the existing server to new server.

sten_still — Wed, 16 Aug 2023 02:05:02 GMT

Hi @Albert_Candelario ,

I have solved the issue by making a new copy of the backup path and able to restore the repository database from the existing server to new server. Seems like the folder not correctly named.

However I'm facing another issue the Qlik Sense Repository Services wont start properly, is this because of the PostgreSQL version is different ;

on existing server is using v9.6 while
new server installed with QPI on the version of v12.5.

Any workaround to restore the QMC setting if the server both on different version without upgrade the PostgreSQL ? Also do Qlik provide any documentation for the different version of PostgreSQL migration ?

Thanks.