Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

野性酷女 2024-02-19 08:16 43阅读 0赞

In this article, we walk you through the requirements and process of how to upgrade and unbundle an existing Qlik Sense Repository Database (see supported scenarios) as well as how to install a brand new Repository based on PostgreSQL. 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][].

> **Using the Qlik Postgres Installer not only upgrades PostgreSQL; it also unbundles PostgreSQL from your Qlik Sense Enterprise on Windows install.** This allows for direct control of your PostgreSQL instance and facilitates maintenance without a dependency on Qlik Sense. Further Database upgrades can then be performed independently and in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions. See [How To Upgrade Standalone PostgreSQL][].

**Index**

*  [Supported Scenarios][]
 *  [Upgrades][]
 *  [New installs][]
 *  [Requirements][]
 *  [Installing anew Qlik Sense Repository Database using PostgreSQL][]
 *  [Qlik PostgreSQL Installer - Download Link][]
 *  [Upgrading anexisting Qlik Sense Repository Database][]
 *  [The Upgrade][]
 *  [Compatibility with PostgreSQL installers][]
 *  [Troubleshooting][]
 *  [Video Walkthrough][]
 *  [Related Content][]

#### **Supported Scenarios** ####

##### **Upgrades** #####

The following versions have been tested and verified to work with QPI 1.3.0 (QPI May 2023):

**Qlik Sense February 2022**to **Qlik Sense** **November 2023**.

If you are on any version *prior* to these, upgrade to at least February 2022 before you begin.

> Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik 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][][.][migrating an existing Database to a separate host]

#### **Requirements** ####

*  Review the [QPI Release Notes][] before you continue
 *  Using the Qlik PostgreSQL Installer on a **patched** Qlik Sense version can lead to unexpected results. If you have a patch installed, either:
    
     *  **Uninstall** all patches before using QPI or
     *  **Upgrade** to an IR release of Qlik Sense which supports QPI
 *  This installer will not detect a standalone PostgreSQL database installed by any other means, other than through an official Qlik installer package.
 *  The user who runs the installer must be an **administrator**.
 *  The backup destination must have **sufficient free disk space** to dump the existing database  
 *  The backup destination must **not be a network path or virtual storage folder**. It is recommended the backup is stored on the main drive. 
 *  The installer itself does not provide an automatic rollback feature.
 *  **There will be downtime during this operation**, please plan accordingly

#### **Installing a new Qlik Sense Repository Database using PostgreSQL** ####

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\\14  
    
7.  Set the **database data folder**, standard: C:\\Program Files\\PostgreSQL\\14\\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][]

#### **Qlik PostgreSQL Installer - Download Link**    ####

[![download.png][]][download.png 1]

Download the installer [here][download.png 1].

[Qlik PostgreSQL installer version 1.3.0 Release Notes][]

####  ####

#### **Upgrading an existing Qlik Sense Repository Database** ####

The following versions have been tested and verified to work with QPI 1.3.0 (May 2023):

**February 2022**to **November 2023**.

If you are on any version *prior* to these, upgrade to at least February 2022 before you begin.

> Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik Sense upgrade.

##### **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.   
    
    
    ![Upgrade Postgre.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 (**b**) **Next**.  
    
    
    ![Qlik Customer Agreement.png][]
    
      
    
6.  Provide your existing **Database superuser password** and click **Next****.**  
    
7.  Define your **Database backup path** and click **Next.**  
    
    
    ![Location of database backup folder.png][]
    
      
    
8.  Define your **Install Location** (default is prefilled) and click **Next**.  
    
    
    ![Location of database installation folder.png][]
    
      
    
9.  Define your database **data** path (default is prefilled) and click **Next**.  
    
    
    ![Location of database data folder.png][]
    
      
    
10. Review all properties and click **Upgrade**.  
      
    The review screen lists the settings which will be migrated. No manual changes are required post-upgrade.  
    
    
    ![Ready to Upgrade the PostgreSQL installation.png][]
    
      
    
11. The upgrade is completed. Click **Close**.  
    
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. The original database folder in C:\\ProgramData\\Qlik\\Sense\\Repository\\PostgreSQL\\X.X\_deprecated
16. Uninstall the old **Qlik Sense Repository** **Database** service.
    
    > **This step is required.** Failing to remove the old service will lead the upgrade or patching issues.
    
    1.  Open a Windows File Explorer and browse to C:\\ProgramData\\Package Cache  
        
    2.  From there, search for the appropriate msi file.  
        
        
        ![search package.png][]
        
          
          
        If you were running 9.6 before the upgrade, search PostgreSQL.msi  
          
        If you were running 12.5 before the upgrade, search PostgreSQL125.msi  
        
    3.  The msi will be revealed.  
        
    4.  Right-click the msi file and select uninstall from the menu.  
        
        
        ![uninstall postgresql.png][]

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

#### **Compatibility with PostgreSQL installers** ####

This version of the upgrade tool is fully compatible with the official PostgreSQL installers from [Community DL Page][].

If you have previously used the Qlik Postgres Installer (version 1.2.1 or earlier), you can simply install the latest PostgreSQL version (within your major release).

Example: You have used the old QPI to upgrade to 12.**5**. You can now easily upgrade to a later version in the *same major release*, such as 12.**15**.

#### **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\\X.X  
      
    The original database data folder has been renamed to:  
      
    C:\\ProgramData\\Qlik\\Sense\\Repository\\PostgreSQL\\X.X\_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 \_][Qlik Sense Upgrade fails with_ This version of Qlik Sense requires a _ database for].  
      
    To resolve this, start the postgresql-x64-XX service.

#### **Video Walkthrough** ####

*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.3.0 Release Notes ][Qlik PostgreSQL installer version 1.3.0 Release Notes]  
[Techspert Talks - Upgrading Qlik Sense Repository Service][]  
[Backup and Restore Qlik Sense Enterprise documentation][]  
[Migrating Like a Boss][migrating an existing Database to a separate host]  
[Optimizing Performance for Qlik Sense Enterprise][]  
[Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL][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][]

[How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version]: https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sense-PostgreSQL/ta-p/1820358
[How To Upgrade Standalone PostgreSQL]: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-How-To-Upgrade-Standalone/ta-p/1712361
[Supported Scenarios]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-1313474511
[Upgrades]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-2004035985
[New installs]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-196581522
[Requirements]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-186078418
[Installing anew Qlik Sense Repository Database using PostgreSQL]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId--1621376045
[Qlik PostgreSQL Installer - Download Link]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-866136788
[Upgrading anexisting Qlik Sense Repository Database]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-1546195158
[The Upgrade]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId--2058210664
[Compatibility with PostgreSQL installers]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId--2068713768
[Troubleshooting]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId--276364414
[Video Walkthrough]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId--2083818877
[Related Content]: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238#toc-hId-403693956
[migrating an existing Database to a separate host]: https://community.qlik.com/t5/Knowledge/Migrating-Qlik-Sense-Enterprise-Like-a-Boss/ta-p/1824119
[QPI Release Notes]: https://community.qlik.com/t5/Official-Support-Articles/Release-Notes-Qlik-Sense-PostgreSQL-installer-version-1-3-0-May/ta-p/2078236
[How to configure Qlik Sense to use a dedicated PostgreSQL database]: https://community.qlik.com/t5/Knowledge/How-to-configure-Qlik-Sense-to-use-a-dedicated-PostgreSQL/ta-p/1791775
[download.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/49fa41aa14f643ea9d53030b9cefd6cd.png
[download.png 1]: https://github.com/qlik-download/qlik-postgresql-installer/releases/
[Qlik PostgreSQL installer version 1.3.0 Release Notes]: https://community.qlik.com/t5/Official-Support-Articles/Release-Notes-Qlik-Sense-PostgreSQL-installer-version-1-3-0/ta-p/2078236
[qlik sense repository database service running.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/18aa6ba97fb641f7a3fb86c2f912d917.png
[Upgrade Postgre.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/57cd86e936b1430489f80a3680b5a5fe.png
[Qlik Customer Agreement.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/799ee6fad2984c7daf92fbd9c3028c91.png
[Location of database backup folder.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/3c64944f2eb74d3faca165ee9bd8e72f.png
[Location of database installation folder.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/491bd3cdb8f64f349eca8854460c99c8.png
[Location of database data folder.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/2b2ddb0d8841434aa12dec6bb96f0ef1.png
[Ready to Upgrade the PostgreSQL installation.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/1d7499728cff44e4b3dc48f0f0fe105e.png
[old service set to manual.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/479a94ec49f74ea5bf05ad36b6d4c051.png
[new service postgresqlx6412.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/c63c1802cfb8419099be24539a76d480.png
[search package.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/78e740f417634acfb50ca1a50b74914e.png
[uninstall postgresql.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/a42013b3c1b34520a3d249677b029ef0.png
[contact Qlik Support]: https://community.qlik.com/t5/Official-Support-Articles/How-to-create-a-case-and-contact-Qlik-Support/ta-p/1710992
[Community DL Page]: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
[Qlik Sense Upgrade fails with_ This version of Qlik Sense requires a _ database for]: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Upgrade-fails-with-This-version-of-Qlik-Sense/ta-p/1715710
[Techspert Talks - Upgrading Qlik Sense Repository Service]: https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-Qlik-Sense-Repository-Database/td-p/1937227
[Backup and Restore Qlik Sense Enterprise documentation]: https://help.qlik.com/en-US/sense-admin/May2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backup-and-restore.htm
[Optimizing Performance for Qlik Sense Enterprise]: https://community.qlik.com/t5/Knowledge/Optimizing-Performance-for-Qlik-Sense-Enterprise/ta-p/1858594
[Qlik Sense Enterprise on Windows_ How To Upgrade Standalone PostgreSQL]: https://community.qlik.com/t5/Knowledge/Qlik-Sense-Enterprise-on-Windows-How-To-Upgrade-Standalone/ta-p/1712361
[How-to reset forgotten PostgreSQL password in Qlik Sense]: https://community.qlik.com/t5/Knowledge/How-to-reset-forgotten-PostgreSQL-password-in-Qlik-Sense/ta-p/1712725
[Troubleshooting Qlik Sense Upgrades]: https://community.qlik.com/t5/Knowledge/Troubleshooting-Qlik-Sense-Upgrades/ta-p/1836860