How to configure Qlik Sense Centralized Logging with Standalone PostgreSQL
Article Number: 000040131 | Last Modified: 2019/01/24
Qlik Sense September 2017 and later provides Centralized Logging, as part of making log management easier by having log contentin a databse rather than on flat files. Qlik Sense installer does not support creating the database when running Qlik Sense towards a native PostgreSQL database ser rather than the Qlik Sense Repository Database.
This article will outline how to configure Centralized Logging when using PostgreSQL as a database source rather than the Qlik Sense Repository Database.
- When at the Configure Centralized Logging step of the installer for Qlik Sense September 2017 on the Central node, uncheck the check box to Configure centralized logging:
- Complete the installation
- Allow apps to migrate
- Issue the following commands to setup the user accounts used by the Logging Service, create the database, and turn the logging on
- "C:\Program Files\Qlik\Sense\Logging"\Qlik.Logging.Service.exe setup --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword
- "C:\Program Files\Qlik\Sense\Logging"\Qlik.Logging.Service.exe update --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword --database_logging on
- Note: If your password for any of these account has special characters, you may need to wrap the password in double quotes. Example --postgres_pswd "p@$$\/\/0rd". Strictly speaking the special characters for Windows command line are <, >, |, &, and ^. But wrapping the passwords in double quotes will eliminate any confusion here.
- Note: This was written assuming a default installation path. You may need to adjust the path from "C:\Program Files\Qlik\Sense\Logging"\ to your installation path.
- Restart services
- If multi-node, then on the RIM nodes:
- Select the Write Logs to an existing standalone database and point to the existing DB location + passwords