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
Have an amazing Qlik Success Story? Share it at QlikWorld! Submit Proposal

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 - New tool available

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 - New tool available

This Support article covers the functionality available in the new Qlik PostgreSQL Installer (QPI), which allows you to upgrade an existing Qlik Sense Repository Database (QRD) from PostgreSQL 9.6 to PostgreSQL 12.5, or install a brand new QRD based on PostgreSQL 12.5.

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

 

Index

 

Environment

 

Supported Scenarios

  • Prior to using QPI, upgrade to the latest supported version of Qlik Sense first and then use QPI to upgrade PostgreSQL. Qlik Sense Enterprise on Windows February 2022 and above are supported versions for QPI. 

    Note: If you are looking to only upgrade your PostgreSQL to 12.5 and do not plan to upgrade Qlik Sense at this point, please wait for the next available release of QPI.

  • Upgrading an existing QRD from PostgreSQL 9.6 to 12.5. Upgrading earlier versions of QRD is not supported via this method. Instead, upgrade to a version of Qlik Sense that supports 9.6 to automatically migrate through this minor version - List of supported PostgreSQL and early Qlik Sense versions

  • Installing a new QRD cluster on a new server, for a new environment or to migrate 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
  • 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. All services on rim nodes must be stopped
  2. Run the Qlik PostgreSQL Installer 
  3. Click on "Install"
  4. Accept the Qlik Customer Agreement
  5. Set your "Local database settings" and click "Next". You will use these details to connect other nodes to the same cluster
  6. Set your "Database superuser password" and click "Next"
  7. Review your settings and click "Install", then click "Finish"
  8. Restore your existing QRD backup OR
  9. Start installing Qlik Sense Enterprise Client Managed, connecting to an existing cluster 
  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

A new service named postgresql-x64-12 is now installed. It is run by the Network Service account. Do not change the name of the service and do not modify the account running it. 

postgressql-x64-12 Network Service.png

The PostgreSQL package can be removed via the Control Panel in case you need to uninstall the database at one point. 

 

Upgrading an existing QRD to PostgreSQL 12.5 - Central Node

It is required to first upgrade Qlik Sense to the latest supported version with QPIQlik Sense Enterprise on Windows February 2022 and above are supported versions for QPI.

Note:
If you are looking to only upgrade your PostgreSQL to 12.5 and do not plan to upgrade Qlik Sense at this point, please wait for the next available release of QPI.

Installations other than in C:\Program Files\Qlik\Sense are not currently supported. 

In this scenario, the new QRD will be using the same port as the old service, and rim nodes do not need any further reconfiguration. 

  1. Stop all services on rim nodes
  2. On your Central Node, stop all services but Qlik Sense Repository Database
  3. Run the Qlik PostgreSQL Installer, an existing Database will be detected
  4. Click on "Upgrade"
  5. Accept the Qlik Customer Agreement
  6. Provide your existing "Database superuser password" and click "Next"
  7. Set your desired backup location and click "Next"
  8. Click "Upgrade", then exit by clicking "Finish"
  9. Start all other services on Central Node
  10. Start all services on all other nodes

A new service named postgresql-x64-12 is now installed. It is run by the Network Service account. Do not change the name of the service and do not modify the account running it. 

postgressql-x64-12 Network Service.png

 

Final steps

At this point, it is important to validate that all services and nodes are operating as expected.

If the upgrade seems to have been unsuccessful and you are missing data in the Qlik Management Console or elsewhere, see Revert/Undo on steps to undo the swap to the new database and ever to the old instance. We also recommend contacting Qlik Support.  

Once the upgrade and all validation are complete, the old Qlik Sense Repository Database service should 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 major PostgreSQL release 12.x or up to version 13.

 

Important Note on postgresql-x64-12

Do not change the name of the new postgres Service postgresql-x64-12 back to e.g. Qlik Sense Repository Database. Renaming the service will impact all of your future upgrades.

 

Qlik PostgreSQL Installer - Download Link

Download the installer here.

Note: The executable was temporarily removed. A new one will be provided as soon as testing is concluded.

 

To revert/undo

  1. Stop the newly installed postgresql-x64-12 service
  2. Set the startup type to Manual.
  3. Start the original Qlik Sense Repository Database service, along with all other Qlik Sense services. 

 

Troubleshooting

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 your temporary files location, 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 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

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

 Click here for video transcript

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:
2 weeks ago
Updated by: