Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report

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

100% helpful (2/2)
cancel
Showing results for 
Search instead for 
Did you mean: 
Bjorn_Wedbratt
Former Employee
Former Employee

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:

Sonja_Bauernfeind

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:

 

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:

Labels (2)
Version history
Last update:
‎2024-08-20 06:08 AM
Updated by: