How to backup or restore the PostgreSQL database in Qlik Sense Enterprise on Windows

[Bjorn_Wedbratt]

Backups are crucial, not only in the case of planned upgrades, migrations, or large-scale infrastructure changes but just as much to have a restore point to fall back to in case of an unplanned failure.

For extensive Backup and Restore instructions applicable to your Qlik Sense Enterprise on Windows version, see: Backup and restore Qlik Sense Enterprise on Windows 

The instructions are broken out into:

• Backing up certificates 
• Restoring certificates 
• Backing up a Qlik Sense site 
• Restoring a Qlik Sense site 

TIP! Do you have a large database? 

If not enough disk space is available, you can shrink the backup by adding  -T _deletedentitylog to your backup command.

Example:

pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -T _deletedentitylog -f "E:\backup\QSR_Backup.tar" QSR ​

Video Walkthrough

For a video walkthrough see: