If you have already uninstalled Qlik Sense, then you have to install a new version rather than upgrade an existing version. During an uninstallation, the PostgreSQL database is not removed by the installer application and it can be restored. These instructions will help you restore the database before installing a new version of Qlik Sense.
Do the following:
- Navigate to %ProgramData%\Qlik\Sense\Repository\PostgreSQL.
- Copy the PostgreSQL folder to a temporary location outside of the %ProgramData% folder.
Download and install a compatible version of PostgreSQL from the PostgreSQL website.
For more information, see Installing and configuring PostgreSQL.
To check the system requirements, see System requirements for Qlik Sense Enterprise.
Open a Command Prompt as a non-admin user.Warning: The pg_ctl.exe command in the next step should not be run as an administrator.
Navigate to %ProgramFiles%\PostgreSQL\<database version>\bin, and run the following commands:pg_ctl.exe start -w -D "C:\SenseDB\<PostgreSQL-version>" set PGUSER=postgres set PGUSER=postgres set PGPASSWORD=password pg_dumpall.exe > [<path to dump file>] pg_ctl.exe stop -w -D "C:\SenseDB\<PostgreSQL-version>"
In the Command Prompt window, navigate to the folder containing the Qlik_Sense_setup.exe file.
Run the following command to install Qlik Sense and restore your Qlik Sense Repository Database.Qlik_Sense_setup.exe databasedumpfile=<path_to_dump_file>Warning: The path to the dump file must be entered as an absolute path. If you enter a relative path, the install will fail.
Now you can install a new version of Qlik Sense.
For more information, see Installing Qlik Sense Enterprise on Windows on a single node.