Upgrading to Qlik Sense June 2017 or later from Qlik Sense versions earlier than 3.1 SR2

Qlik Sense June 2017 and later versions do not support the synchronized persistence model. To upgrade to Qlik Sense June 2017 or later from any version of Qlik Sense earlier than 3.1 SR2 and migrate from a synchronized to shared persistence model, do the following:

1. Create a backup of your existing Qlik Sense deployment. For more information, see the help for the version of Qlik Sense that you are currently running.

2. Change the PostgreSQL authentication mode in the configuration settings to allow the password to be changed.

   1. Stop the Qlik Sense repository database service.
   2. Open the Client Authentication file located in ProgramData\Qlik\Sense\Repository\PostgreSQL\<database version>\pg_hba.conf .
   3. Change the ADDRESS to 127.0.0.1/32, and change the METHOD to trust for for IPv4 local connections and local host replication.
   4. Change the ADDRESS to ::1/128, and change the METHOD to trust for IPv6 local connections and local host replication.
   5. Start the Qlik Sense repository database service.

3. Change the Qlik Sense repository database password.
   To change the password using PostgreSQL command line:

   1. Open a command prompt and navigate to ProgramFiles\Qlik\Sense\Repository\PostgreSQL\<database version>\bin.

   2. Connect to the database by entering the following command:

      psql.exe -p 4432 -U postgres.

   3. Enter the following command to set the new user password:

      ALTER USER qliksenserepository WITH PASSWORD '<newpassword>';

      ALTER ROLE is displayed after successfully changing the password.

   To change the password using the pgAdmin tool:

   1. Launch pgAdmin and connect to the Qlik Sense repository database.

   2. Expand the tree in the left pane and click Login Roles > qliksenserepository.
   3. Right-click on qliksenserepository and select Properties.
   4. Click the Definition tab, and enter a Password.

4. Reset the PostgreSQL authentication mode in the configuration settings to require authentication.

   1. Stop the Qlik Sense repository database service.
   2. Open the Client Authentication file located in ProgramData\Qlik\Sense\Repository\PostgreSQL\<database version>\pg_hba.conf .
   3. Change the METHOD back to md5.

   4. Start the Qlik Sense repository database service.

5. Create a database dump file.

   If Qlik Sense is installed:

   1. Stop all Qlik Sense services except Qlik Sense repository database service. Ensure that the Qlik Sense repository database service is running.

   2. Open a command prompt and navigate to the location where the PostgreSQL database is installed, and enter the following commands:

      • set PGUSER=postgres

      • set PGPASSWORD=[superuserpassword]

      • pg_dumpall.exe -p 4432 > [path to dump file]

   If Qlik Sense has been uninstalled:

   1. Copy the PostgreSQL folder from %ProgramData%\Qlik\Sense\Repository\PostgreSQL\9.6 to a temporary location outside of the %ProgramData%\Qlik folder.
   2. Download and install PostgreSQL version 9.6 from the PostgreSQL website. For more information, see Installing and configuring PostgreSQL.
   3. Open a Command Prompt in Microsoft Windows.
   4. Navigate to the location where the PostgreSQL repository database is installed, cd "%ProgramFiles%\PostgreSQL\9.6\data\bin", and run the following commands:
   • pg_ctl.exe start -w -D "C:\SenseDB\9.6"
   • set PGUSER=postgres
   • set PGPASSWORD=password
   • pg_dumpall.exe > [path to dump file]
   • pg_ctl.exe stop -w -D "C:\SenseDB\9.6"
6. Make a backup of log and application data in the following folders:
   • %ProgramData%\Qlik\Sense\Log
   • %ProgramData%\Qlik\Sense\Apps
   • %ProgramData%\Qlik\Sense\Repository\Content
   • %ProgramData%\Qlik\Sense\Repository\Extensions
   • %ProgramData%\Qlik\Sense\Repository\AppContent (if available)
   • %ProgramData%\Qlik\Sense\Repository\SharedContent (if available)
7. Make a backup of any locations where content that supports the Qlik Sense environment may be kept (for example, QVD files created by load scripts).
8. Create a file share, see Creating a file share.

9. Create the following sub-folders in the file share:

   • Apps
   • ArchivedLogs
   • CustomData
   • StaticContent

10. Copy following content from your synchronized persistence deployment to the file share:

    Content	Copy from	To subfolder
    Apps	..\ProgramData\Qlik\Sense\Apps	Apps
    Logs (optional)	..\ProgramData\Qlik\Sense\Repository\Archived Logs	ArchivedLogs
    Static content	..\ProgramData\Qlik\Sense\Repository\AppContent ..\ProgramData\Qlik\Sense\Repository\Content ..\ProgramData\Qlik\Sense\Repository\DefaultContent ..\ProgramData\Qlik\Sense\Repository\Extensions ..\ProgramData\Qlik\Sense\Repository\DefaultApps ..\ProgramData\Qlik\Sense\Repository\SharedContent Information noteEach of these folders must be added as a sub-folder of the StaticContent folder.	StaticContent

11. Ensure that all Qlik Sense nodes are synchronized, and take all nodes offline by stopping the Qlik Sense services in Windows.
12. Uninstall Qlik Sense. Accept the defaults when uninstalling to preserve the certificates settings.

13. In the Command Prompt window, navigate to the folder containing the Qlik_Sense_setup.exe file.

14. 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 noteThe path to the dump file must be entered as an absolute path, using a relative path will result in an installation failure.
15. Uninstall Qlik Sense on each of your rim nodes in multi-node deployment. Select the option to completely uninstall Qlik Sense when you uninstall on the rim nodes.
16. Install Qlik Sense on each of the rim nodes.
17. Connect the rim nodes in the QMC, select each node, and click the Redistribute button.