Qlik sense Repository database backup

[#1]

Hi

we have single server running Qlik Sense in our production environment. we want to take daily backup of repository database.Is it compulsory to stop services to take QRD backup ? we dont want to stop services on weekdays and in future we will plan to expand servers so that we can take it down at any point of time.

Please let us know any thoughts on this

Thanks

[hemhund2016]

In ideal scenario , it is a good practice to stop all the qlik sense services to get the backup of QRD.

However, you can still make a backup without stopping all services.

        Open the Command Prompt in Microsoft Windows.

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

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

            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.

            Make a backup of the dumpfile for the repository database.

[#3]

‌Thanks for the reply. What is the procedure to set this as a job rather than manual step since we have to enter password

Thanks

[#4]

In addition, there is a repository snapshot tool.  Please see Qlik Help here: Backing up and restoring a site

[petter]

If you use the -w option for pgdump.exe you can provide password in the .pgpass file. Check the Postgresql manual on how to do it.