Creating a PostgreSQL database dump file after uninstalling Qlik Sense

[Lisa_Sun]

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:

• Qlik Sense Enterprise on Windows  

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

1. Copy the PostgreSQL folder from %ProgramData%\Qlik\Sense\Repository\PostgreSQL to a temporary location outside of the %ProgramData% folder.
2. Download and install PostgreSQL version 9.6 from the PostgreSQL website.
3. Open a Command Prompt in Microsoft Windows.
   The pg_ctl.exe command should not be run as an administrator.
4. 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>"