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!
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 standalone database based on
PostgreSQL
14.8, or when upgrading and unbundling an existing bundled database from
PostgreSQL
9.6 and
PostgreSQL
12.5 to
PostgreSQL
14.8.
About the
Qlik PostgreSQL Installer
As of March 2023,
PostgreSQL
9.6 is no longer supported. Using the
QPI
when upgrading to
PostgreSQL
14.8 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 bundled
PostgreSQL
setup is detected, the
QPI
starts the installation process.
The default installation path is
C:\Program Files\PostgreSQL\14
. Data for the new database is stored at
C:\Program Files\PostgreSQL\14\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 note
Using 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:
Clean installation of
PostgreSQL
14.8. The
QPI
allows to install a standalone
PostgreSQL
14.8 database on a new server for a new environment, or to migrate an existing database to a separate host.
Upgrade an existing bundled database from
PostgreSQL
9.6 and 12.5 to 14.8. 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
.
Information note
Upgrading earlier versions of the
Qlik Sense Repository Database
(
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.
Before you start installing or upgrading, consider the following:
Using the
QPI
on a patched
Qlik Sense
version might lead to unexpected issues. If you have a patch installed, follow these steps:
Uninstall all patches for your current
Qlik Sense
version (for example, revert Feb 2022 Patch X to Feb 2022 IR).
Use
QPI
to upgrade the
PostgreSQL
database.
Finally, upgrade
Qlik Sense
to your desired version.
Alternatively:
Upgrade
Qlik Sense
to an IR (initial release) of a later version that supports
QPI
.
Use
QPI
to upgrade the
PostgreSQL
database.
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.
When using the
QPI
to upgrade the bundled
PostgreSQL
database, it not only upgrades the database to 14.8, but also unbundles it from
Qlik Sense Enterprise on Windows
installation.
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
14.8
Do the following:
Stop all services on rim nodes.
Run the
Qlik PostgreSQL Installer
.
Click
Install
.
Accept the
Qlik
Customer Agreement
.
Set the
Local database settings
and click
Next
. You will use these details to connect other nodes to the same cluster.
Set the
Database superuser password
and click
Next
.
Review the settings and click
Install
and then
Finish
.
Upgrading an existing
Qlik Sense Repository Database
using
PostgreSQL
14.8 - Central node
Information note
It 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:
Stop all services on the rim nodes.
On your central node, stop all services except the
Qlik Sense Repository Database
service.
Run the
Qlik PostgreSQL Installer
. The installer will detect the existing database.
Click
Upgrade
.
Accept the
Qlik
Customer Agreement
.
Enter your
Database superuser password
and click
Next
.
Set the backup location and click
Next
.
Click
Upgrade
and then
Finish
.
A new service named
postgresql-x64-14
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.
Start all services except the
Qlik Sense Repository Database
service.
Start all services on the rim nodes.
Validate that all services and nodes are operating as expected.
Once the upgrade and all validation are complete, remove the old
Qlik Sense Repository Database
from the server.
Information note
This step is required. Failing to remove the old service will lead to upgrade or patching issues.
