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

How To Connect To The PostgreSQL Database Used For Qlik Sense Repository

cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How To Connect To The PostgreSQL Database Used For Qlik Sense Repository

Qlik Sense use PostgreSQL as the repository database. The below steps show how to use the PostgreSQL client (pgAdmin) to connect to the Qlik Sense repository.

WARNING: Always have a backup of the underlying PostgreSQL database prior to performing any direct modifications of the database. Refer to the pg_dump portion on https://help.qlik.com for the commands to perform a backup.

WARNING: Manual modification of Qlik Sense Repository Database is not supported and can cause product failure. Direct modification should be done in consultation with Qlik Support and only as a last resort. The database within Qlik Central node is for use by the Qlik Application alone. 

  1. Stop all services except the Qlik Sense Repository Database
  2. Run pgAdmin3.exe from the Program Files path for Qlik Sense (by default C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin)
  3. Click the power plug button on the top manual bar and enter the following information 
    Name - QSR (this is arbitrary)
    Server - localhost
    Port - 4432 (not the default of 5432)
    User Name - postgres
    Password - the password that you provided on installation.

    User-added image
  4. Press Ok and expend to view the connected database
    User-added image
  5. If you need to run a query then click on the query icon, highlighted below
    User-added image


If you are making edits to the underlying database in a multi-node deployment then complete these steps as well as having backups:

  • Stop all services on all nodes
  • Make the same edits to all nodes
  • On the Central node: create a blank file named _operation.qrs in C:\ProgramData\Qlik\Sense\Repository\Transaction Logs. This will simulate an abnormal shutdown and force the Central to attempt to resync with the RIM nodes
  • Start services on the Central to verify that everything works as expected
  • Start services on the RIM(s)

 

In any development need to extract information from the repository database in a supported way, the Qlik Sense APIs must be used.

More details please refer to the online manual

 

Labels (1)
Version history
Last update:
‎2021-09-22 12:23 PM
Updated by: