Qlik Sense Repository Back up and Restore

刺骨的言语ヽ痛彻心扉 2022-09-13 05:18 22阅读 0赞

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][Official Document_ Backup and restore Qlik Sense Enterprise on Windows]

## Backup Qlik Sense Repository Database ##

1.  Stop all Qlik Sense services except the `Qlik Sense Repository Database`( please only keep this one QRD), on every node in your deployment.
2.  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.
3.  Make a backup of all of the content in the file share.
4.  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`
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.  Restart the Qlik Sense services.

## Restore Qlik Sense Repository Database ##

1.  Start the Qlik Sense `Repository Database` (QRD) service (please stop other services and only keep this one).
2.  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"`
3.  Run `dropdb -h localhost -p 4432 -U postgres QSR` to drop the database. (Expect you should have one , else please ignore it )
4.  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)
5.  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`
6.  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.`
7.  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

[Official Document_ Backup and restore Qlik Sense Enterprise on Windows]: https://help.qlik.com/en-US/sense-admin/August2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backup-and-restore.htm