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
- pg_ctl.exe start -w -D "C:\SenseDB\<database version>"
- set PGUSER=postgres
- set PGPASSWORD=password
- pg_dumpall.exe > [<path to dump file>]
- pg_ctl.exe stop -w -D "C:\SenseDB\<database version>"