Skip to main content

Official Support Articles

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
Skip the ticket, Chat with Qlik Support instead for instant assistance.

How to find and read the PostgreSQL database logs after setting up Centralized Logging, regarding QLogs

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

How to find and read the PostgreSQL database logs after setting up Centralized Logging, regarding QLogs

Attachments

If you set up Centralized Logging in a newer version of Qlik Sense, this article explains how to access the new centralized logging Postgre database and its logs.

 

  1. Follow Articles Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti... which provide instructions on how to access the Qlik database using the pgAdmin tool.
  2. Once connected, expand "Databases", and then expand the centralized logging database called "QLogs"
  3. Expand "Schemas", then "Public", then "Tables"
  4. Right-click on "log_entries" and choose "View All Rows"

    000045416a.jpg

  5. This will take quite a few minutes to load, so do not click on the screen as to avoid the pgAdmin tool from stalling
  6. Once the logs load, a new window will appear, showing the logger and the specific log messages

    000045416b.jpg

    Please keep in mind, however, that the true purpose for centralized logging is for the Qlik Sense monitoring applications to read from them. They are not truly for customer usage, as they are less easily read than the logs recorded in the Log folder within the Sense directory. If you are asked to send logs to Qlik Support, please use the Sense Log Collector tool (in Article How To Collect Qlik Sense Log Files) to gather all logs from C:\ProgramData\Qlik\Sense\Log, rather than sending in any database logs or error messages.

    Additional information about centralized logging, which was introduced in Qlik Sense September 2017, can be found using the following links:

    Qlik Logging Service
    Logging - Qlik Sense for administrators
Labels (3)
Version history
Last update:
‎2021-09-03 09:35 AM
Updated by: