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

Bjorn_Wedbratt — Tue, 20 Aug 2024 10:08:43 GMT

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:

article How to backup or restore the PostgreSQL database in Qlik Sense Enterprise on Windows in Official Support Articles

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

Video Walkthrough