PostgreSQL update needed?

[Lauri]

I used the QPI last year to unbundle and update postgresql while on a 2023 version of Sense. I'm now migrating Qlik Sense to a new server, so I installed the same version of Sense (February 2024) on the new server. When I tried restoring the backup files from the old server, I got a lot of pg_restore errors. Do I first need to update postgres on my old server to the same version of postgres as comes with February 2024, and then take a backup again? If so, how do I know which version of postgres?  Thanks for any help.

[Chetan_MN]

Hi @Lauri I would suggest you to install the same version of Qlik Sense on the new server, restore backup and then upgrade the Qlik Sense version.

Standalone DB can be upgraded as per the procedure in below article.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-How-To-Upgr...

[Lauri · Accepted solution]

It turns out my errors were due to the fact that I allowed the Qlik services to start (because I installed a Qlik patch), and so the new DB tables got created BEFORE i tried to restore them. Apparently it's OK to restore from/to different subversions of postgres (e.g., 14.x).