Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Need to take a backup of qlik sense repository backup from windows and restore the database in Postregs AWS RDS.
I am able to take the backup but i am not able to restore the backup.
Can some one help with the correct procedure/Steps.
Hi,
Follow this steps :
Start the Qlik Sense Repository Database (QRD).
Open a Command Prompt with administrator privileges in Microsoft Windows.
cd "%ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
createdb -h localhost -p 4432 -U postgres -T template0 QSR
If the command fails because a database already exists, run the following command and then repeat the createdb command:
dropdb -h localhost -p 4432 -U postgres QSR
pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\QSR_backup.tar"
Restore log and application data to the file share used for storage of log and application data.
Qlik Sense Repository Service (QRS)
If the user running Qlik Sense services is not local administrator on the machine, you need to start Repository.exe from an elevated command prompt using the -bootstrap parameter.
The order is important because the QRS is dependent on the QRD and the rest of the services are dependent on the QRS.
for more information you can check this link below