Backing up a site manually

This section describes how to backup a Qlik Sense site in a default installation where a PostgreSQL database is used as the repository database.

The procedure described in this section can also be performed using the Repository Snapshot Manager (RSM).

See: Using the Repository Snapshot Manager

Items to backup

The following items need to be considered when backing up a site:

• Repository database: The database contains all configuration data for the site.
• Certificates for the Qlik Sense services: The certificates are used to encrypt the traffic between the services and the users. Make sure to backup the certificates in order not to lose any encrypted data (for example, passwords for data connections).
• Log data
• Application data: The data models in the Qlik Sense apps.
• Any content that supports the apps (for example, QVD files)

Backup procedure

Proceed as follows to backup a Qlik Sense site:

1. Make a backup of the certificates used to secure the Qlik Sense services. This only needs to be done once.

See: Backing up certificates

2. Stop all Qlik Sense services except the Qlik Sense Repository Database (QRD).
3. Make a backup of the repository database:

   1. Open the Command Prompt in Microsoft Windows.

   2. Produce a dumpfile for the repository database (that is, a single file for the entire database):

      1. cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"

      2. pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR_backup.tar" QSR

      If you are prompted for the PostgreSQL super user password, enter the password that was given during the installation of Qlik Sense.

      3. Make a backup of the dumpfile for the repository database.
4. Make a backup of the following folders:
• %ProgramData%\Qlik\Sense\Log
• %ProgramData%\Qlik\Sense\Apps
• %ProgramData%\Qlik\Sense\Repository\Content
• %ProgramData%\Qlik\Sense\Repository\Extensions
5. 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).
6. Start the Qlik Sense services. If the services are started manually, start them in the following order:
Information noteThe user that installs and runs the Qlik Sense services must be local administrator on the machine.
1. Qlik Sense Repository Service (QRS)
2. Qlik Sense Proxy Service (QPS), Qlik Sense Engine Service (QES), Qlik Sense Scheduler Service (QSS), Qlik Sense Printing Service (QPR), and Qlik Sense Service Dispatcher (QSD) in no specific order

The order is important because the QRS is dependent on the QRD and the rest of the services are dependent on the QRS.