Release Notes Qlik Sense PostgreSQL installer version 1.2.0 to 1.4.0

[Sebastian_Linser]

The following release notes cover the Qlik PostgreSQL installer (QPI) version 1.2.0 to 1.4.0.

Content

• What's New
• 1.4.0 December 2023 Release Notes
• Known Limitations (1.4.0)
• 1.3.0 May 2023Release Notes
• Known Limitations (1.3.0)
• 1.2.0 Release Notes

 

What's New

Silent install/upgrade is supported beginning with Qlik PostgreSQL Installer 1.4.0 and later. QPI can now be used with silent commands to install or upgrade the PostgreSQL database. (SHEND-973)

1.4.0 December 2023 Release Notes

Improvement / Defect	Details
SHEND-1359, QB-15164: Add support for encoding special characters for Postgres password in QPI	If super user password is set to have certain special characters, QPI did not allow upgrading PostgreSQL using this password. The workaround was to set a different password, use QPI to upgrade the PostgreSQL database and then reset the password after the upgrade. This workaround is not required anymore with 1.4.0 QPI, as 1.4.0 supports encoded passwords.
SHEND-1408: Qlik Sense services were not started again by QPI after the upgrade	QPI failed to restart Qlik services after upgrading the PostgreSQL database. This has been fixed now.
SHEND-1511: Upgrade not working from 9.6 database	In QPI 1.3.0, upgrade from PostgreSQL 9.6 version to 14.8 was failing. This issue is fixed in QPI 1.4.0 version.
QB-21082: Upgrade from May 23 Patch 3 to August 23 RC3 fails when QPI is used before attempting upgrade. QB-20581: May 2023 installer breaks QRS if QPI was used with a patch before.	Using QPI on a patched Qlik Sense version caused issues in the earlier version. This is now supported.

Known Limitations (1.4.0)

• QB-24990: Cannot upgrade PostgreSQL if Qlik Sense was installed in a custom directory such as D:\Sense. See Qlik PostgreSQL Installer (QPI): No supported existing Qlik Sense PostgreSQL database found.
• Rollback is not supported.
• Database size is not checked against free disk space before a backup is taken.
• QPI can only upgrade bundled PostgreSQL database listening on the default port 4432. Using QPI to upgrade a standalone database or a database previously unbundled with QPI is not supported.
• Cannot migrate a 14.8 embedded DB to standalone
• Windows Server 2012R2 does not support PostgreSQL 14.8. QPI cannot be used on Windows Server 2012R2.

 

1.3.0 May 2023 Release Notes

Improvement / Defect	Details
SHEND-1261: Allow upgrade from the bundled postgres version 12.5 to 14.8 version using QPI	You can now update the embedded Qlik Sense Repository Database from versions 9.6 and 12.5 to version 14.8. (This is due to the following security issues of PostgreSQL)
SHEND-971: Allow custom Qlik Sense Installation Folder for use with QPI	When Qlik Sense is installed outside of the standardfolder C:\Program Files\Qlik\Sense e.g. (D:\Qlik\Sense), QPI can now be used to migrate the database.
QB-17384: Users were allowed to create folder names which are not allowed in Windows	Fixed the issue that it was possible to create a folder with the following charaters  (/,:,*,?,",<,>,|) which are not approved by Windows.

Known Limitations (1.3.0)

• Silent installation or upgrade is not available
• 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
• The summary of Database settings during the upgrade shows not the actual values of the pg_hba.conf
• Rollback is not available
• Database size is not checked against free disk space before a backup is taken.
• Supported are only upgrades of a Qlik Sense Repository Database installed as an embedded Database with the initial installation. You can not upgrade a standalone or QPI converted/installed database.
• QB-15164: Certain strings and characters cannot be used in the installation with QPI, the command line option for Postgres will not parse them in the command prompt. We have blocked & $ " @ ^ § to be used in the dialogue. If you run into that issue, please change the password to a simpler one before the use of QPI, you can change it back right after the upgrade. (This is anticipated to be fixed in 1.4.0).
• Windows Server 2012R2 does not support PostgreSQL 14.8. QPI cannot be used on Windows Server 2012R2.

To download the Qlik PostgreSQL installer and review the mandatory documentation, see Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5.

1.2.0 Release Notes

Improvement / Defect	Details
SHEND-1106: Support custom install in Qlik PostgreSQL installer	It is now possible to select where to install the Postgres Database.
SHEND-1066: Add Custom Upgrade
SHEND-1125: Default paths not set in Qlik PostgreSQL installer.	Installation and data paths are set to default PostgreSQL paths, instead of default Qlik Sense paths.
SHEND-1074: Installation sometimes starts when you navigate forward and back in the installation wizard.
SHEND-1169: Update gradle plugins for new java version
SHEND-1173: Installation fails if the data folder is created inside the installation folder.

Related Content

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 
Qlik Sense upgrade to November 2022 fails with "An existing standalone PostgresSQL v 12 database has... 

[Sebastian_Linser]

Improvement / Defect	Details
SHEND-1261: Allow upgrade from the bundled postgres version 12.5 to 14.8 version using QPI	You can now update the embedded Qlik Sense Repository Database from versions 9.6 and 12.5 to version 14.8. (This is due to the following security issues of PostgreSQL)
SHEND-971: Allow custom Qlik Sense Installation Folder for use with QPI	When Qlik Sense is installed outside of the standardfolder C:\Program Files\Qlik\Sense e.g. (D:\Qlik\Sense), QPI can now be used to migrate the database.
QB-17384: Users were allowed to create folder names which are not allowed in Windows	Fixed the issue that it was possible to create a folder with the following charaters  (/,:,*,?,",<,>,|) which are not approved by Windows.

Known Limitations (1.3.0)

• Silent installation or upgrade is not available
• 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
• The summary of Database settings during the upgrade shows not the actual values of the pg_hba.conf
• Rollback is not available
• Database size is not checked against free disk space before a backup is taken.
• Supported are only upgrades of a Qlik Sense Repository Database installed as an embedded Database with the initial installation. You can not upgrade a standalone or QPI converted/installed database.
• QB-15164: Certain strings and characters cannot be used in the installation with QPI, the command line option for Postgres will not parse them in the command prompt. We have blocked & $ " @ ^ § to be used in the dialogue. If you run into that issue, please change the password to a simpler one before the use of QPI, you can change it back right after the upgrade. (This is anticipated to be fixed in 1.4.0).
• Windows Server 2012R2 does not support PostgreSQL 14.8. QPI cannot be used on Windows Server 2012R2.

To download the Qlik PostgreSQL installer and review the mandatory documentation, see Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5.

1.2.0 Release Notes

Improvement / Defect	Details
SHEND-1106: Support custom install in Qlik PostgreSQL installer	It is now possible to select where to install the Postgres Database.
SHEND-1066: Add Custom Upgrade
SHEND-1125: Default paths not set in Qlik PostgreSQL installer.	Installation and data paths are set to default PostgreSQL paths, instead of default Qlik Sense paths.
SHEND-1074: Installation sometimes starts when you navigate forward and back in the installation wizard.
SHEND-1169: Update gradle plugins for new java version
SHEND-1173: Installation fails if the data folder is created inside the installation folder.

Related Content

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 
Qlik Sense upgrade to November 2022 fails with "An existing standalone PostgresSQL v 12 database has... 

[karthiksrqv]

Hi,

Another query related to this silent installer:

In this article: https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

it is mentioned in step 17, that we need to re-install the binaries.

However, this is not mentioned in

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_De...

Is step 17 needed when we do silent install or not? Please clarify.

Regards,
Karthik

[Sonja_Bauernfeind]

Hello @karthiksrqv 

I can confirm that Step 17 is necessary - and I have logged an improvement request with our documentation team to have the documentation updated. Thank you for raising this!

Have a wonderful day!

All the best,
Sonja 

[karthiksrqv]

Thanks @Sonja_Bauernfeind 

A follow-up query:

During the upgrade, we notice that "postgresql-14.8-1-windows-x64.exe" appears in the folder. Our understanding is this is embedded in the Qlik PostgreSQL Installer and not downloaded

There is no internet connectivity required for the Qlik PostgreSQL Installer to work. Is this correct?

Please confirm.

[Sonja_Bauernfeind]

Hello @karthiksrqv This is the new PostgreSQL database installer. 

It is included in QPI.

All the best,
Sonja 

[karthiksrqv]

Thanks @Sonja_Bauernfeind .

Can you please confirm if any Internet connectivity is needed for QPI at all? Does it connect in any way to Qlik/PostgreSQL/Any other sites?

[Sebastian_Linser]

@karthiksrqv while it will work without a internet connection, the legal documents and instruction you check of at the beginning are stored online.

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_De...

https://www.qlik.com/us/-/media/files/legal/license-agreements/qlik/qlik-customer-agreement-english....

best regards

Sebastian

[karthiksrqv]

Ok @Sebastian_Linser . I'll take that as a confirmation that the 'silent install' option will work without any internet connectivity.

Thanks for the note.

[Sonja_Bauernfeind]

Hello @karthiksrqv 

Correct.

[heij1421]

I use the Qlik Sense February 2023 release still with postgres 9.6 and I want to update and unbundle.

This 9.6 version was not installed in the standard location c:\program files\qlik\sense

The QPI version 1.4 doesn't detect this location while version 1.3 does (Solved: Qlik PostgreSQL Installer doesn't detect database - Qlik Community - 2447279)
and I cannot use QPI 1.3 as it doesn't convert a Postgres 9.6 (release notes of 1.4: In QPI 1.3.0, upgrade from PostgreSQL 9.6 version to 14.8 was failing. This issue is fixed in QPI 1.4.0 version), . Any advice?

Can this bug in 1.4 being fixed to check the right older location of the installed progres version?

[Sebastian_Linser]

Hello @heij1421,

 it will be fixed with the next QPI release. For your issue however please open a case with the Qlik support and we will migrate the DB with you. 

best regards

Sebastian