Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
A. Stop all Qlik Sense Services except for "Qlik Sense Repository Database" on Windows Server manager (services.msc)
B. Create c:\backup folder
C. Open CMD.ext as administrator
D. Go to "bin" folder
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
Note: the directory will likely be "9.3" not "9.6" if an older version is running.
E. Take PostgreSQL backup
Command: pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR
F. Check the backup file side after command finished. the file size shouldn't zero.
G. If E. fails and the cause is free space left on C: you could try -T _deletedentitylog and provide a different driver -T _deletedentitylog -f "E:\backup\QSR_Backup.tar" QSR
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.