Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Creating a PostgreSQL database dump file after uninstalling Qlik Sense

cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Sun
Support
Support

Creating a PostgreSQL database dump file after uninstalling Qlik Sense

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:

  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>"
Labels (1)
Version history
Last update:
‎2021-05-07 05:30 AM
Updated by:
Contributors