topic Old Database data imported into PostgreSQL 16 in Management & Governance

Old Database data imported into PostgreSQL 16

TommyG — Fri, 07 Mar 2025 15:06:46 GMT

I can see/hear that PostgreSQL 16 is now supported by QlikSense, and from this page I see how were are supposed to set it up...

https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-configuring-postgresql.htm#Granting

...but in the SQL Script I don't see how the old data is copied over to these new QSR, SenseServices, QSMQ, Licenses databases.

How do we copy the data from these old databases over to the new ones? (pardon my ignorance if that old data doesn't matter)

Re: Old Database data imported into PostgreSQL 16

Alan_Slaughter — Fri, 07 Mar 2025 20:16:57 GMT

Hi TommyG, this should help:

https://community.qlik.com/t5/Official-Support-Articles/How-To-Take-Backup-And-Restore-Qlik-Sense-Enterprise-on-Windows/ta-p/1717548

https://help.qlik.com/en-US/sense-admin/November2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backup-and-restore.htm

Re: Old Database data imported into PostgreSQL 16

TommyG — Mon, 10 Mar 2025 11:12:43 GMT

Thank you very much for that Alan, at first glance that's exactly what I'm looking for, I'll get diving into those pages.

Thank you again

Re: Old Database data imported into PostgreSQL 16

TommyG — Wed, 19 Mar 2025 14:17:52 GMT

Hi there,

Sorry to reply to my forum entry which already has a solution, but just figured it would be better for anyone else searching with the same questions to find them all in one entry:-

I've had time to look into these pages and I can see what I have to do to the "QSR" database (thank you!), but - apart from running the SQL Script on the page I reference in the OP as the last step - I am still unsure about the below...

Should I back up and import the "SenseServices" database also? (It sounds like - based on what it is - I should do)
Do I need to do anything with the "Licenses" database? (because it's on the same server, it doesn't look like I do)
Do I need to do anything to the "QSMQ" database? (as it doesn't hold anything that would need to be historically referenced, it doesn't look like I do)

Thank you for your time