Qlik Sense Repository Back up and Restore-蒲公英云

Qlik Sense Repository Back up and Restore

For all steps please see the official document , we only taking backup for the Qlik Sense Repository Database , also you can call it postgreSQL backup and restore .

(Official Document) Backup and restore Qlik Sense Enterprise on Windows

Backup Qlik Sense Repository Database

Stop all Qlik Sense services except the Qlik Sense Repository Database( please only keep this one QRD), on every node in your deployment.
Make a backup of the repository database by creating a database dump file:
- Open a Command Prompt in Microsoft Windows. (CMD or powershell all fine)
- Navigate to the location where the PostgreSQL repository database is installed.
- Note:If your deployment includes a local database on the central node that was installed using the Qlik Sense setup program, the location will be:
  %ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\<database version>\bin.
  Note:If you installed PostgreSQL manually, the location will be:
  %ProgramFiles%\PostgreSQL\<database version>\bin.
  Run the following command:
  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 created during the Qlik Sense setup.
- Tip:To avoid being prompted for the password(for example, if you want to automate the Qlik Sense backup process), you can use the pgpass functionality in PostgreSQL. See the PostgreSQL documentation for more information.
Make a backup of all of the content in the file share.
If you have centralized logging configured, make a backup of the centralized logging database by running the following command:
pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QLogs_backup.tar" QLogs
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).
Restart the Qlik Sense services.

Restore Qlik Sense Repository Database

Start the Qlik Sense Repository Database (QRD) service (please stop other services and only keep this one).
Open a Command Prompt with administrator privileges in Microsoft Windows. And then navigate to the pgsql bin folder: cd "%ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
Run dropdb -h localhost -p 4432 -U postgres QSR to drop the database. (Expect you should have one , else please ignore it )
Run createdb -h localhost -p 4432 -U postgres -T template0 QSR to create a QSR database (If the command fails because a database already exists, you get the following error message: createdb: database creation failed: ERROR: database “QSR” already exists)
Run the following command to restore the repository database on a clean server:
pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\QSR_backup.tar
To launch Qlik Sense with the new or different hostname , need to execute the following command:
Repository.exe -bootstrap -standalone -restorehostname , When the command has completed successfully check for erros in the logs and the following message is displayed:
Bootstrap mode has terminated. Press ENTER to exit.
Start the Qlik Sense services. If the services are started manually, start them in the following order
- Qlik Sense Service Dispatcher
- Qlik Logging Service
- Qlik Sense Repository Service
- Qlik Sense Proxy Service
- Qlik Sense Engine Service
- Qlik Sense Scheduler Service
- Qlik Sense Printing Service