For full instructions on how to backup and restore a Qlik Sense site, see the online help under Backing up a Qlik Sense site. For some illustrated documentation on backing up the Qlik Sense site see How To Take Backup And Restore Qlik Sense June 2017 or higher
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
Note that <database version> reflects the version of your PostgreSQL install. \pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -f "c:\backup\QSR_backup.tar" QSR
h: Hostname
p: Port number
U: User ID
v: verbosity (adds logging)
Note: If postgres db password is unknown, see How-to reset forgotten PostgreSQL password in Qlik Sense
-T _deletedentitylog -f "E:\backup\QSR_Backup.tar" QSR
For detailed information see Restoring a Qlik Sense site.
Run the following commands to restore the repository database (adjust the paths as needed):
cd "%ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
Note that <database version> reflects the version of your PostgreSQL install. 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:\backup\QSR_backup.tar"
"%Programfiles%\Qlik\Sense\Repository\PostgreSQL\9.6\bin\dropdb.exe" -h localhost -p 4432 -U postgres QSR