Skip to main content

Official Support Articles

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 using the Qlik PostgreSQL Installer

cancel
Showing results for 
Search instead for 
Did you mean: 
Mario_Petre
Support
Support

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 using the Qlik PostgreSQL Installer

In this article, we walk you through the requirements and process of how to upgrade an existing Qlik Sense Repository Database from PostgreSQL 9.6 to PostgreSQL 12.5 (see supported scenarios) or install a brand new Repository based on PostgreSQL 12.5.

We will use the Qlik PostgreSQL Installer (QPI).

For a manual method, see: How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version 

PostgreSQL 9.6 has reached End of Life Reference: PostgreSQL Versioning Policy.

 

Index

 

Supported Scenarios

  • Upgrades: Before using the Qlik PostgreSQL Installer, upgrade to a supported version of Qlik Sense Enterprise on Windows. Then use the Qlik PostgreSQL Installer to upgrade PostgreSQL.

    We tested and validated Qlik Sense Enterprise on Windows from February 2022 to February 2023. Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Sense upgrade.

  • New installs: The Qlik PostgreSQL Installer supports installing a new Qlik Sense Repository Database cluster on a new server, setting up a new environment or migrating an existing Database to a separate host.

 

Considerations

  • This installer will not detect a standalone PostgreSQL database installed by any other means, other than through an official Qlik installer package, installed on the standard folders in the C drive. 
  • The installer itself does not provide a rollback feature. This is described below. 
  • The user who runs the installer has sufficient permissions to execute it and install services 
  • The user who runs the installer has sufficient permissions to create folders and files in the backup destination 
  • The backup destination has sufficient free disk space to dump the existing database  
  • The backup destination is not a network path or virtual storage folder. It is recommended the backup is stored on the main drive 
  • There will be downtime during this operation, please plan accordingly 

 

Installing a new Qlik Sense Repository Database using PostgreSQL 12.5

  1. Run the Qlik PostgreSQL Installer as an administrator 

  2. Click on Install 

  3. Accept the Qlik Customer Agreement 

  4. Set your Local database settings and click Next. You will use these details to connect other nodes to the same cluster. 

  5. Set your Database superuser password and click Next

  6. Set the database installation folder, standard: C:\Program Files\PostgreSQL\12

  7. Set the database data folder, standard: C:\Program Files\PostgreSQL\12\data

  8. Review your settings and click Install, then click Finish

  9. Start installing Qlik Sense Enterprise Client Managed. Choose Join Cluster option.

    The Qlik PostgreSQL Installer has already seeded the databases for you and has created the users and permissions. No further configuration is needed.


  10. The tool will display information on the actions being performed. Once installation is finished, you can close the installer.  

    If you are migrating your existing databases to a new host, please remember to reconfigure your nodes to connect to the correct host. How to configure Qlik Sense to use a dedicated PostgreSQL database 

 

Upgrading an existing QRD to PostgreSQL 12.5

Before using the Qlik PostgreSQL Installer, upgrade to a supported version of Qlik Sense Enterprise on Windows. Then use the Qlik PostgreSQL Installer to upgrade PostgreSQL.

We tested and validated Qlik Sense Enterprise on Windows from February 2022 to February 2023. Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Sense upgrade.

Qlik Sense Enterprise on Windows installations other than in C:\Program Files\Qlik\Sense are currently not supported. 

 

The Upgrade:

  1. Stop all services on rim nodes 

  2. On your Central Node,stop all services except the Qlik Sense Repository Database 

    qlik sense repository database service running.png

  3. Run the Qlik PostgreSQL Installer. An existing Database will be detected. 

    detected postgre version.png

  4. Highlight the database and click Upgrade 
  5. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (bNext.

    read and accept customer agreement.png

  6. Provide your existingDatabase superuser password and click Next.

  7. Define your Database backup path and click Next.

    define database backup path.png

  8. Define your Install Location (default is prefilled) and click Next.

    define install location.png

  9. Define your database data path (default is prefilled) and click Next.

    database data folder.png
     
  10. Review all properties and click Upgrade.

    review and upgrade.png

  11. The upgrade is completed. Click Close.

    completed upgrade of postgre.png
     
  12. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services.

    You will find that the Qlik Sense Repository Database service has been set to manual. Do not change the startup method. 

    old service set to manual.png

    You will also find a new postgresql-x64-12 service. Do not rename this service. 

    new service postgresqlx6412.png

  13. Start all services except the Qlik Sense Repository Database service. 

  14. Start all services on your rim nodes.

  15. Validate that all services and nodes are operating as expected.

If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.  

  1.  

Finalizing the Upgrade/Uninstalling the old Database Service:

No further steps are needed unless you plan to upgrade Qlik Sense Enterprise on Windows to the next major release. If you plan to upgrade to, for example, November 2022, the old Qlik Sense Repository Database service must be removed from the server.

Perform the following steps to delete the Qlik Sense Repository Database Service:

  1. Open a command prompt and run the command:
    c:\cd ProgramData\Package Cache
  2. From there, run:
    c:\ProgramData\Package Cache\dir /s PostgreSQL.msi
  3. The folder containing PostgreSQL.msi will be revealed.
  4. Right-click on the PostgreSQL.msi file and select uninstall from the menu.

 

Compatibility with PostgreSQL installers

This version of the upgrade tool is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

If you need to upgrade to a higher release than Qlik provides, you can install the same minor PostgreSQL release 12.x.

 

Qlik PostgreSQL Installer - Download Link

 

Download the installer here.

Qlik PostgreSQL installer version 1.2.1 Release Notes

 

Troubleshooting

  1. If the installation crashes, the server reboots unexpectedly during this process, or there is a power outage, the new database may not be in a serviceable state. Installation/upgrade logs are available in the location of your temporary files, for example:

    C:\Users\Username\AppData\Local\Temp\2

    A backup of the original database contents is available in your chosen location, or by default in:

    C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6

    The original database data folder has been renamed to:

    C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6_deprecated

  2. Upgrading Qlik Sense after upgrading PostgreSQL with the QPI tool fails with:

    This version of Qlik Sense requires a 'SenseServices' database for multi cloud capabilities. Ensure that you have created a 'SenseService' database in your cluster before upgrading. For more information see Installing and configuring PostgreSQL.

    See Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _.

    To resolve this, start the postgresql-x64-12 service.

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. The video in this article was recorded in a earlier version of QPI, some screens might differ a little bit.

 

Related Content

Qlik PostgreSQL installer version 1.2.1 Release Notes  
Techspert Talks - Upgrading Qlik Sense Repository Service
Backup and Restore Qlik Sense Enterprise documentation
Migrating Like a Boss
Optimizing Performance for Qlik Sense Enterprise
Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL
How-to reset forgotten PostgreSQL password in Qlik Sense
How to configure Qlik Sense to use a dedicated PostgreSQL database
Troubleshooting Qlik Sense Upgrades

Labels (2)
Comments
RaviGinqo
Partner - Contributor II
Partner - Contributor II

HI Mario,

That's a great  tool for helping with postgreSQL upgrade and making it smoother unlike Uninstall/re-install steps. 

Do you know when this tool will be available for download?  We have upgrade planned and just wanted to make sure that if its available sooner or should we wait for couple of weeks.

Also do you think that after verifying that new PostgreSQL service/DB works fine, should Service be renamed to Qlik Sense Repository Database for future upgrades? would you recommend that?

How future upgrades will change with Two services for Repository Database  - Postgre and Qlik Sense Repository DB?

 

Thanks

Ravi

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @RaviGinqo Let me get some clarity for you on this!

khartmann2
Partner - Contributor
Partner - Contributor

Hi,

where can i download the installer? It is not available on the download portal.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @khartmann2 

If you mean the tool mentioned in this article: This is not yet available. We will update the article when it is. 

Sonja_Bauernfeind
Digital Support
Digital Support

@RaviGinqo Hello Ravi,

The tool is still with our developers, but we will update this article when it is released. I would recommend subscribing to it.

As for your second question: Please do not rename the service. 

 

All the best,
Sonja 

RaviGinqo
Partner - Contributor II
Partner - Contributor II

Thank you @Sonja_Bauernfeind 

By any chance do you know if it will available this month? If so, I can plan our upgrades accordingly.

Ravi

SivenM2020
Partner - Contributor III
Partner - Contributor III

Hello,

Yes, we are also looking for this tool. Please let us know when its ready, so we can start testing in our environment.

Kind Regards,

Siven

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @RaviGinqo and @SivenM2020 

I will reply in this thread once we have it and alert everyone who has actively asked for it. Hopefully, the tool will be available next week.

All the best,
Sonja 

SDW
Contributor
Contributor

hi, where can i download this tool?

Sonja_Bauernfeind
Digital Support
Digital Support

@SDW @SivenM2020 @RaviGinqo @khartmann2 

Hello all,

For the time being: if you’re interested in upgrading the PostgreSQl Repository database to 12.5 using this installer, please make a request for the installer via the Case Portal so that Qlik can assist you with this upgrade.

All the best,
Sonja 

Version history
Last update:
18 hours ago
Updated by: