Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12.5 version

Bastien_Laugiero

Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12.5 version

Starting at Qlik Sense Enterprise on Windows May 2021, the bundled PostgreSQL has been upgraded to version 12.5

However, PostgreSQL 12.5 will only be deployed during a fresh installation of Qlik Sense Enterprise on Windows May 2021. This means that, if you are upgrading to Qlik Sense Enterprise on Windows May 2021, PostgreSQL will remain on 9.6.

For many organizations, running on the latest supported PostgreSQL version is a security requirement. To achieve this:

 

Environment

  • Qlik Sense Enterprise on Windows May 2021

 

The information in this article is provided as-is and to be used at your own discretion. Depending on the tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

This process requires a full reinstallation of the product. Despite the fact that a backup is being taken as part of the process, it is highly recommended to have a second backup plan in place such as a Virtual Machine snapshot and/or a Server Backup. 

It is highly recommended to test this process in a test environment to get familiar with it. 

 

Step 1: Upgrading your Qlik Sense site

The first step is to upgrade your environment to Qlik Sense Enterprise on Windows May 2021 following the steps and recommendations provided on this link.

Once the upgrade is done make sure your Qlik Sense site is completely operational.

 

Step 2: Backing up your Qlik Sense site

At this point, you have an operational Qlik Sense site running on Qlik Sense Enterprise on Windows May 2021, however, the bundled PostgreSQL is still on version 9.6.

The next step will be to backup your entire Qlik Sense site following these instructions (including the certificates) . The backup is essential as it will need to be restored later on. 

 

Step 3: Uninstall Qlik Sense on the central node

You will now need to uninstall Qlik Sense from the central node following these instructions. 

During the uninstall:

  • Check the box Remove Qlik Sense demo apps, certificates and data folders.
  • Have all rim nodes stopped. 

 

Step 4: Install Qlik Sense Enterprise on Windows May 2021 on the central node

Now that Qlik Sense Enterprise on Windows May 2021 is uninstalled on the central node, you will reinstall it as a result will deploy a bundled PostgreSQL 12.5.  Instructions available here.

Do not check the box Start theQlik Senseservices when the setup is complete at the end of the installer.

 

Step 5: Restoring your Qlik Sense site

You now have a clean Qlik Sense Enterprise on Windows May 2021 deployed on your central node with PostgreSQL 12.5. You now need to restore your environment to retrieve all your configurations and apps.

Please follow the Restoring a Qlik Sense site (including the certificates).

Note: While restoring the database backup you will most likely receive the following error which can be ignored.  This error is caused by the version discrepancies between the pg_dump that made the dump file and the pg_restore that's restoring it - in example files coming from PostgreSQL version 9.6 vs files coming from PostgreSQL version 12.5. QSR backup taken and restored with the same version of PostgreSQL will not produce that error.

 

 

pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3; 2615 2200 SCHEMA public postgres
pg_restore: error: could not execute query: ERROR:  schema "public" already exists
Command was: CREATE SCHEMA public;


pg_restore: warning: errors ignored on restore: 1

 

 

Once the environment is restored, you should be able to start your central node and rim nodes successfully. 

 

Labels (3)
Comments
AlexOmetis
Partner
Partner

Hi,

I just ran through this with an upgrade from May 2021 Patch 1 to August 2021 Patch 2. When I did it the first time I was still left with Postgres 9.6. I then uninstalled again, removed the remnants of C:\Program Files\Qlik\Sense and restarted the server. This time it worked and I got Postgres 12.5.

I don't know if it was because it was the second attempt, the restart or the removal of files that led to this but at least it's working now. When I tried for the first time to re-install Patch 2 after the main August 2021 install I got a message saying that the patch had been previously installed and I needed to reboot. I wonder if the registry of installed software hadn't updated or something. My advice would be to reboot after the uninstall and clear out the folder anyway! 

mjht
Contributor III
Contributor III

Will Qlik Sense require an upgrade to PostgreSQL version 12.5 at some point?  We are still planning to use version 9.6 unless required to upgrade.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @mjht 

There are eventual plans to do so, yes. But the Release Notes for the versions will always tell you what version of PostGre is supported.

santhoshkumar
Contributor III
Contributor III

any articles for RDS upgrade? 

Version history
Last update:
‎2021-08-19 02:30 AM
Updated by: