Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL
This document is not supported and is meant only as a guide. Individual environments may require adjustments for things to work correctly. Standalone PostgreSQL database server instances are not covered by the Qlik Support Maintenace Agreement.
This guide covers deployments where PostgreSQL has been installed separately and not through the Qlik Sense installer. For deployments where PostgreSQL is installed by Qlik Sense installer no manual action is required at the time of update unless described in Release Notes or Upgrading and updating Qlik Sense Enterprise on Windows
At the outset this document covers the following scenario:
Windows Server OS. The use of Linux, in managed cloud deployments or on-prem, is not covered.
Generic PostgreSQL deployment. Stream replication, SSL, or any other advanced configuration are not covered.
Make sure to only create those which did not exist prior to your DB move.
2. Upgrading PostgreSQL
Practically PostgreSQL 9.6 database server is not upgraded to PostgreSQL 11.x. The newer version is installed in parallel and the database is migrated from version 9.6 to 11.x. In this walk-through, the migration is done by using SQL Dump to export and then import the Qlik Sense Repository Database.
This guide will assume that you are using the same password for the postgres (and qliksenserepository) user accounts in 11.x and in use in 9.6, so deviation from this assumption will require additional configuration which will not be covered.
After installation, ensure that both PostgreSQL 9.6 and 11.x are shut down in the Windows services applet (Start > Run > services.msc)
Ensure that the pg_hba.conf and postgres.conf files are configured the same between the builds.
Default path for the 9.6 files C:\Program Files\PostgreSQL\9.6\data
Once the 11.x .conf files are configured to mirror the 9.6 versions, start the postgresql-x64-11.8 service
At this point, you will want to either uninstall PostgreSQL or disable the service so that it does not start after a server reboot. Disabling is ideal for the short-term to validate the rest of the upgrade goes smoothly
Upgrading Qlik Sense
On the Central node for Qlik Sense, run the installer as administrator
There is a relatively exhaustive page on the step by step on help.qlik.com
After upgrade, open the QMC to ensure that the apps migrated successfully