Creating a PostgreSQL database dump file after uninstalling Qlik Sense

Lisa_Sun — Fri, 07 May 2021 09:30:01 GMT

We recommend creating your database dump file before uninstalling Qlik Sense. Even if Sense was already uninstalled (as long as the database was not removed), a backup can still be taken.

Environment:

If you uninstall Qlik Sense before creating the database dump file, do the following:

Copy the PostgreSQL folder from %ProgramData%\Qlik\Sense\Repository\PostgreSQL to a temporary location outside of the %ProgramData% folder.
Download and install PostgreSQL version 9.6 from the PostgreSQL website.
Open a Command Prompt in Microsoft Windows.
The pg_ctl.exe command should not be run as an administrator.
Navigate to the location where the PostgreSQL repository database is installed, %ProgramFiles%\PostgreSQL\<database version>\bin, and run the following commands
1. pg_ctl.exe start -w -D "C:\SenseDB\<database version>"
2. set PGUSER=postgres
3. set PGPASSWORD=password
4. pg_dumpall.exe > [<path to dump file>]
5. pg_ctl.exe stop -w -D "C:\SenseDB\<database version>"

article Creating a PostgreSQL database dump file after uninstalling Qlik Sense in Official Support Articles

Creating a PostgreSQL database dump file after uninstalling Qlik Sense