STT - Upgrading PostgreSQL Repository Troubleshooting

[Troy_Raney]

This Techspert Talks session covers:

• Using the Qlik Sense QPI tool
• Upgrading a Stand-Alone Database
• How to resolve common issues

Chapters:

• 01:02 - Intro to PostgreSQL Repository
• 02:51 – Prerequisites
• 03:24 - What is the QPI tool?
• 05:09 - Using the QPI tool
• 09:27 - Removing the old Database Service
• 11:27 - Upgrading a stand-alone to the latest release
• 13:39 - How to roll-back to the previous version
• 14:46 - Troubleshooting upgrading a patched version
• 18:25 - Troubleshooting upgrade security error
• 21:15 - Additional config file settings
• 22:52 - Q&A: Are Initial Releases good to run?
• 23:29 - Q&A: When is next release of QPI tool?
• 24:00 - Q&A: Which versions have security issues?
• 24:36 - Q&A: Is version 16 recommended?
• 24:55 - Q&A: What order should upgrades be done in?
• 25:30 - Q&A: Will QS May 2022 work with latest PostgreSQL?
• 25:55 - Q&A: Are settings saved with an upgrade?
• 26:42 - Q&A: Is the upgrade process different if on D drive?
• 27:25 - Q&A: Are there any certificate concerns?
• 27:47 - Q&A: Can the Repository password be changed?
• 28:08 - Q&A: Why the error about running 9.6 after upgrade?
• 28:42 - Q&A: How to upgrade QS WITH the bundled repository?
• 29:30 - Q&A: Is upgrading PostgreSQL needed with QS 2024?
• 30:18 - Q&A: Can we run a Test environment with the same license?

Resources:

• Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer
• Installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer
• Backing up a Qlik Sense site
• Changing the Database Superuser Password without Qlik Sense Installed
• PostgreSQL Download site

@Sebastian_Linser