Bjorn_Wedbratt
Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to backup or restore the PostgreSQL database in Qlik Sense Enterprise on Windows
Last Update:
Aug 20, 2024 6:08:43 AM
Updated By:
Created date:
Oct 9, 2020 3:17:19 AM
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:
27,176 Views