Skip to main content Skip to complementary content
Qlik Resources

Installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer

The Qlik PostgreSQL Installer (QPI) facilitates your installation or upgrade of the bundled PostgreSQL database. The QPI can be used when installing a completely new database based on PostgreSQL 12.5, or when upgrading an existing database from PostgreSQL 9.6 to PostgreSQL 12.5.

About the Qlik PostgreSQL Installer

As of March 2023, PostgreSQL 9.6 is no longer supported. Using the QPI when upgrading to PostgreSQL 12.5 simplifies the upgrade. The QPI also makes the installation of a new database easier.

When you launch the QPI, it detects any already existing PostgreSQL setup and starts the upgrade process. If no PostgreSQL setup is detected, the QPI starts the installation process.

The default installation path is C:\Program Files\PostgreSQL\12. Data for the new database is stored at C:\Program Files\PostgreSQL\12\data.

You can change these paths, as long as they don't use the old path: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5. The change of paths is made to decouple PostgreSQL from Qlik Sense and facilitate maintenance and upgrading. With this change there is no dependency on upgrades to Qlik Sense Enterprise on Windows. Any attempt to use the old installation path is automatically prevented to avoid issues with the database being interpreted as bundled by the installer when upgrading.

The QPI only supports Qlik Sense Enterprise on Windows February 2022 and above.

When upgrading, the database backup is stored in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\backup\9.6. The 9.6 folder is renamed to 9.6_deprecated, to avoid accidental references to the old 9.6 folder.

Information noteUsing the Qlik PostgreSQL Installer not only upgrades PostgreSQL; it also unbundles PostgreSQL from your Qlik Sense Enterprise on Windows installation. 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.

Supported scenarios

You can use the QPI in the following scenarios:

  • Making a clean installation of PostgreSQL 12.5. The QPI only supports Qlik Sense Enterprise on Windows February 2022 and above. It's recommended that you upgrade to the latest supported version of Qlik Sense before using the QPI.

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

  • Installing a new QRD cluster on a new server, for a new environment, or migrate an existing database to a separate host.

For more information about the QPI, see: Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer.

Considerations

Before you start installing or upgrading, consider the following:

  • The QPI will not detect a standalone PostgreSQL database installed by any other means other than through an official Qlik installer package.

  • The QPI itself does not provide a rollback feature.

  • The user who runs the QPI needs to have sufficient permissions to execute the QPI and install services.

  • The user who runs the QPI needs to have sufficient permissions to create folders and files in the backup destination.

  • The backup destination needs to have sufficient free disk space to dump the existing database.

  • The backup destination is not a network path or virtual storage folder. It's recommended to store the backup on the main drive.

  • There will be downtime during this operation, plan accordingly.

Installing a new Qlik Sense Repository Database using PostgreSQL 12.5

Do the following:

  1. Stop all services on rim nodes.

  2. Run the Qlik PostgreSQL Installer.

  3. Click Install.

  4. Accept the Qlik Customer Agreement.

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

  6. Set the Database superuser password and click Next.

  7. Review the settings and click Install and then Finish.

  8. Do one of the following:

    1. Restore your existing QRD database, see: Restoring a Qlik Sense site.

    2. Start installing Qlik Sense Enterprise Client-Managed, see: How to configure Qlik Sense to use a dedicated PostgreSQL database.

  9. When the installation is complete, close the installer.

  10. Click Finish to complete the installation.

Upgrading an existing Qlik Sense Repository Database using PostgreSQL 12.5 - Central node

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

Do the following:

  1. Stop all services on the rim nodes.

  2. On your central node, stop all services except the Qlik Sense Repository Database service.

  3. Run the Qlik PostgreSQL Installer. The installer will detect the existing database.

  4. Click Upgrade.

  5. Accept the Qlik Customer Agreement.

  6. Enter your Database superuser password and click Next.

  7. Set the backup location and click Next.

  8. Click Upgrade and then Finish.

    A new service named postgresql-x64-12 is now installed. It's run by the Network Service account. Don't change the name of the service and don't modify the account running it.

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

  10. Start all services on the rim nodes.

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

  12. Once the upgrade and all validation are complete, remove the old Qlik Sense Repository Database from the server.

    Information noteThis step is required. Failing to remove the old service will lead the upgrade or patching issues.

    1. Open a command prompt and run the following command:

      c:\cd ProgramData\Package Cache

    2. From there, run:

      c:\ProgramData\Package Cache\dir /s PostgreSQL.msi

      The folder containing PostgreSQL.msi is displayed.

    3. Right-click the PostgreSQL.msi file and select Uninstall from the menu.

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here